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

=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