sumif multiple columns
=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}"
--
If this post helps click Yes
---------------
Jacob Skaria
"Mona" wrote:
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
|