SUMIF - Can I total the value of cells if three other cells = set

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Thank you so much, spent ages trying to work that one out, think Ive fried my
brain.

ANyway, your help is much appreciated, you're a genuis!!!
 
=SUMPRODUCT(--(A1:A20="mon"),--(B1:B20="ax"),--(C1:C20="dec"),D1:D20)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Back
Top