SUMIF Formula Problem
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
|