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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Addition help to edit a formula 7
Help with editing a formula 7
Find a word in a table, then use a function 3
Extract specific information from the body of outlook mail to an Excel File using VBA 0
Return the cell reference of the drop down list selection. 1
Copy columns, but not hidden ones 3
sumif column of month are the same 7
Help with SUMIF & AND function 2

Back
Top