sumif multiple columns


M

Mona

Thanks in advance!

Data
A B C D E
1/2/2009 3 1 3 2
1/3/2009 2 5 2 6
1/4/2009 1 3 1 3

If column A=1/3/2009 then add column C + column E. Thanks a bunch
 
Ad

Advertisements

P

Peo Sjoblom

One possible way


=SUMPRODUCT(--(A2:A10=DATE(2009,1,4)),(C2:C10)+(E2:E10))

--


Regards,


Peo Sjoblom
 
P

Peo Sjoblom

One possible way


=SUMPRODUCT(--(A2:A10=DATE(2009,1,4)),(C2:C10)+(E2:E10))

--


Regards,


Peo Sjoblom
 
J

Jacob Skaria

=SUM(IF($A$1:$A$100=DATE(2009,3,1),$C$1:$C$100+$E$1:$E$100))

Please note that this is an array formula. Within the cell in edit mode (F2)
paste this formula and press Ctrl+Shift+Enter to apply this formula. If
successful in the Formula Bar you can notice the curly braces at both ends
"{=<formula>}"
 
Ad

Advertisements

J

Jacob Skaria

=SUM(IF($A$1:$A$100=DATE(2009,3,1),$C$1:$C$100+$E$1:$E$100))

Please note that this is an array formula. Within the cell in edit mode (F2)
paste this formula and press Ctrl+Shift+Enter to apply this formula. If
successful in the Formula Bar you can notice the curly braces at both ends
"{=<formula>}"
 

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

Top