SUMIF Formula Problem
Hello.
If you are a XL2007 user, use SUMIFS, otherwise, give a try to :
=SUMPRODUCT(('1'!A:A=A5)*('1'!B:B=A6)*'1'!J:J)
HTH
Daniel
Hi to all,
Wonder if you can help me. I have the following formula which works ok, is
it possible to have a similar formula but with extended choice of cells:
SUMIF('1'!A:A,A5,'1'!J:J)
Example: The present formula will compare 1!A:A with A5, I would like a
formula to compare 1!A:A,A5 and 1!B:B giving the same result from 1J:J
1!A:A being a category like Travel Expenses,
1!B:B being a department like Sales Department
1!J:J being the Cost
Thank You
Albert
|