How to determine the values?
 

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

How to determine the values?
 

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)

--
Regards,

OssieMac


"Eric" wrote:

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