Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to determine the values? | Excel Worksheet Functions | |||
How to determine the values from a list? | Excel Worksheet Functions | |||
How to determine the values from a list? | Excel Discussion (Misc queries) | |||
I need to determine how frequently two values appear together | Excel Discussion (Misc queries) | |||
How to determine geometric mean of 152 values? | Excel Worksheet Functions |