Hi Dan, You were very helpful with my last question, I hope you can help me with this one.
I have the following sheet in workbook:
in sheets "jan", "feb", "mar" I have long list of expenses in column A. In column B, I have the I have names of expense categories.
I want to add the expenses by category.
I know how to do it for each month.
For example in F1 I had the text "office", that is one of the categories, G1 I wanted the total for category "office", so I did the following formula:
=Sumif('jan'!B1:B100,F1'jan'!A1:A100) and it worked fine.
However, I want the totals in the sheet "year" I want the range to include B1:B100 from sheets jan, feb, and mar.
How do I do it?
I already tried:
=Sumif('jan'!C1:100+'feb'!C1:100,F1,'jan!'B1:B100+'feb'!B1:B100) and it didn't work.