View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Eric Eric is offline
external usenet poster
 
Posts: 1,670
Default 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