Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumif multiple columns
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumif multiple columns
One possible way
=SUMPRODUCT(--(A2:A10=DATE(2009,1,4)),(C2:C10)+(E2:E10)) -- Regards, Peo Sjoblom "Mona" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumif multiple columns
Try this:
H1 = 1/3/2009 =SUMPRODUCT(--(A1:A10=H1),C1:C10+E1:E10) -- Biff Microsoft Excel MVP "Mona" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumif from multiple columns | Excel Worksheet Functions | |||
sumif for multiple columns | Excel Worksheet Functions | |||
SUMIF and multiple columns | Excel Discussion (Misc queries) | |||
SUMIF over multiple columns | Excel Worksheet Functions | |||
Sumif over multiple columns | Excel Worksheet Functions |