| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting non-zero cells based on date
Can someone please help with this? I can't seem to figure it out. Say I
have one column with a list of dates and another with values that are either zero or non-zero. How do I count the number of nonzero cells in the second column after today? For example: Column B Column C 3/20/2007 6.5 3/21/2007 0.0 3/22/2007 3.2 3/23/2007 7.8 If today is 3/20/2007 I want Excel to only count the values in Column C for 3/21-3/23 that are non-zero |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting non-zero cells based on date
try
=sumproduct(--(B1:B100today()),--(C1:C100<0)) "Rochelle" wrote: Can someone please help with this? I can't seem to figure it out. Say I have one column with a list of dates and another with values that are either zero or non-zero. How do I count the number of nonzero cells in the second column after today? For example: Column B Column C 3/20/2007 6.5 3/21/2007 0.0 3/22/2007 3.2 3/23/2007 7.8 If today is 3/20/2007 I want Excel to only count the values in Column C for 3/21-3/23 that are non-zero |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting non-zero cells based on date
Thanks a lot! That worked. Now I just have to figure out why it worked lol
"Rochelle" wrote: Can someone please help with this? I can't seem to figure it out. Say I have one column with a list of dates and another with values that are either zero or non-zero. How do I count the number of nonzero cells in the second column after today? For example: Column B Column C 3/20/2007 6.5 3/21/2007 0.0 3/22/2007 3.2 3/23/2007 7.8 If today is 3/20/2007 I want Excel to only count the values in Column C for 3/21-3/23 that are non-zero |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| counting Ps and Ls based on the date in another row. | Excel Worksheet Functions | |||
| counting cells based on formatting | Excel Discussion (Misc queries) | |||
| Counting based on other cells contents... | Excel Discussion (Misc queries) | |||
| Complicated counting of cells (based on other cells contents) | Excel Worksheet Functions | |||
| Counting unique records based on date range | Excel Worksheet Functions | |||
Linear Mode
