I have searched over the internet and this forum and I cant find a way to apply it too my situation.

For the sakes of this post I will take out the different sheet references and instead show it as if it all on the same sheet.

=SUMIFS(F7:F1000,D7:D1000,C37,I7:I1000,P2:P5))

Im trying to get this too work.

So F7:F1000, is the data to be added together

D7:D1000 = the year

C37 = 2014

I7:I1000 = category, so this has stuff like (food shopping, fuel, car, bills, utilities etc)

P2:P5 = three criterias ([Balance], [Cashback], [Transfer])

Im trying to sum together the values which is 2014, and has the text [Balance] or [Cashback] or [Transfer] in the category column.


Thanks!