sum if with an and

M

Marlaine

I have 3 columns of data, A contains the type, B contains the quarter and C
contains the value to add. I was to add up all the "Any" types in "Q1!. I
thought I was pretty clever with the following equation but it returns the
#VALUE!.

=IF(A3:A15="Any",SUMIF(B3:B15,"Q1",C3:C15),0)

It appears to be around A3:A15 but I cant figure out why. I made sure
everything was text that should be. I am still on Excel 2003 so cannot use
SUMIFS which someone showed me.
 
P

Per Jessen

Hello Marlaine

Try this formla:

=SUMPRODUCT(--(A3:A15="Any"),--(B3:B15="Q1"),C3:C15)

Regards,
Per
 

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

lookup within an IF formula 3
Help with formula 0
sum working hours each month (sum hours in the last row for a monthin a table with dates) 3
PLEASE HELP TO MATCH ALL SHEET AND THEN MERGE, 1
Help with a Sum and an Array 15
subtotal with sumif nested 1
Looking to added up based on a character from cell range 1
datevalue returns #value 5

Top