I have an issue with the third condition on the "sumifs" function - I need to create a function to look at an expense category for a month, then a year and total it in a summary sheet against the respective months' column as a comparative table. Since there are multiple years, there is a problem, and the values result in zeros. It works well with two conditions and reflects the values, but the third condition results in zero values. My table should pick the year from a drop-down cell marked as a constant. =SUMIFS(Table1[Debit],Table1[Category],'Annual Summary'!$B4,Table1[Month],'Annual Summary'!$C$2,Table1[Year],'Annual Summary'!$T$3) is the formula used. Can you help me in correcting the error?
very nice, but i use only google sheet and 6.40 you used test so which test formula i can use in google sheet bcz many test option ava. here plz tell me
Excellent 👌 but please add working file so I can follow along 🙏
Nice & very informative
Very very helpful
I have an issue with the third condition on the "sumifs" function - I need to create a function to look at an expense category for a month, then a year and total it in a summary sheet against the respective months' column as a comparative table. Since there are multiple years, there is a problem, and the values result in zeros. It works well with two conditions and reflects the values, but the third condition results in zero values. My table should pick the year from a drop-down cell marked as a constant. =SUMIFS(Table1[Debit],Table1[Category],'Annual Summary'!$B4,Table1[Month],'Annual Summary'!$C$2,Table1[Year],'Annual Summary'!$T$3) is the formula used. Can you help me in correcting the error?
very nice, but i use only google sheet and 6.40 you used test so which test formula i can use in google sheet bcz many test option ava. here plz tell me
Thanks
thx
How to run monthly & Item vice summery
Man I followed this all exactly and it did not work. Idk if I have a diff version of excel but it wasn't working for me.