How to determine the values?

E

Eric

Does anyone have any suggestions on how to determine the values?
There is a list of numbers under column A, and date under column B, which
will be available if and only if data is given. For example,

1 3-Oct-2008
5
9 3-Oct-2008
6
7

The sum is 1+9 = 10, which will return in cell C1.
Does anyone have any suggestions on how to do it?
Thanks in advance for any suggestions
Eric
 
O

OssieMac

Assuming that the numbers in your example in cells A1:A5 and the dates are
within the range B1:B5 then you could use the following formula in say A6

=SUMIF(B:B,">0",A1:A5)
 
Top