How to determine the values?

  • Thread starter Thread starter Eric
  • Start date Start date
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
 
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)
 

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

How to determine the values? 1
How to determine the value? 1
How to use index and match function for determining the value? 1
How to determine the occurrence? 9
How to determine the value? 5
How to determine the text? 3
How to determine the value? 2
How to determine the value? 3

Back
Top