Home |
Search |
Today's Posts |
#1
|
|||
|
|||
sumif Q
how can I use SUMIF function to add up only those values in column B
if a date is specified in column A? tried if A is not empty then sum it up, i.e. =SUMIF(A1:A10,"<"" ",B1:B10) and this didn't work for me. A B 10 7-May 11 15 4-May 21 5-May 9 32 Thanks in advance for any help, /mark |
#2
|
|||
|
|||
=SUMIF(A1:A6,"<",B1:B6)
-- Regards, Peo Sjoblom (No private emails please) "Mark Dvorkin" wrote in message ... how can I use SUMIF function to add up only those values in column B if a date is specified in column A? tried if A is not empty then sum it up, i.e. =SUMIF(A1:A10,"<"" ",B1:B10) and this didn't work for me. A B 10 7-May 11 15 4-May 21 5-May 9 32 Thanks in advance for any help, /mark |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
Dynamic sumif function | Excel Worksheet Functions | |||
SUMIF Not | Excel Discussion (Misc queries) | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions | |||
SUM(IF( Array to avoid #NUM! values | Excel Worksheet Functions |