sumif Q

M

Mark Dvorkin

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
 
P

Peo Sjoblom

=SUMIF(A1:A6,"<>",B1:B6)

--
Regards,

Peo Sjoblom

(No private emails please)
 

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

Similar Threads

SUMIF with criteria "<>" & "=" 4
sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A" 9
SUMIF result including values not specified in sum-range 2
Sumif using Arrays 2
Sumif where sum range is more than one column? 1
How to Count values inside a cell when refered elsewhere? 4
SUMIF Help (Excel 2002) 1
sumif 1

Top