I am trying to do a SUMIFS formlua for this data:
Data Set.png
I have tried all three of these formulas, which brought up errors:
=SUMIFS(Q2:Q2000,"Mailer", J2:J2000,(H2:H2000, "2010")
=SUMIFS(Q2:Q2000,"Mailer", J2:J2000,("2010", J2:J2000)
=SUMIFS(Q2:Q2000,"Mailer", J2:J2000,("2010", H2:H2000)
Here is the origional SUMIF formula that I am basing my SUMIFS formula from:
=SUMIF(Q2:Q2000,"Mailer",J2:J2000)
And this is what my SUMIF forumla brings up on my spreadsheet:
SUMIF data.png
I want to see the total for only those numbers in column J, whos column Q equals "Mailer" and whos column H equals "2010"
Why cant I figure this out?????!!!! Please help!
Bookmarks