SUMIF - Can I total the value of cells if three other cells = set
Hi,
Once again I need your help.
Suppose I have a spreadsheet that looks pretty much like this but much
larger!!!...
A B C D
1 mon ax dec 0.23
2 Tue ax dec 1.75
3 mon ax acc 0.78
I need a formula that will, for example, give me the total of the values in
column D for all rows where Column A = Mon, B = AX and C = dec
Any ideas????
Your help would be much appreciated.
Regards
John
|