Sumif in 3 rows

[TTB008]

Hi,

Please help with an excel formular.
I am wanting to return the sum of values that meet 2 critera, and return that value only. So i have in col A i have the date by month, in col K i have the department code, and in col I i have the amount.

I am trying to set up a running sheet by month that gives me the value each department spent in a particular month and have used the following formular: =IF(AND(SUMIF($K$7:$K$59,$B4,$I$7:$I$59),(SUMIF($A$7:$A$59,C$3,$I$7:$I$59))),(SUMIF($K$7:$K$59,$B4,$I$7:$I$59)),0) with B4 being the department code and C3 being the date.

This formular works untill the department has an expense in 2 months, the it adds the expense in both months.

Any assistance would be greatly appricated.

Cheers

[NBVC]

Try Sumproduct:

e.g

=SUMPRODUCT(($K$7:$K$59=$B4)*($A$7:$A$59=C$3),$I$7:$I$59)

[TTB008]

Thank you for your suggestion, however it does not seem to return any value at all nor does it return an error. Do you think it is missing something??

[NBVC]

My formula will sum numbers in I7 to I59 where corresponding items K7:K59 = B4 and A7:A59 = C3.

Is that not what you were looking for?