Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Column A contained a unique identifier for each record. I want to be able to
count the number of records with 0's, if a date is also recorded for the same unique number. Ex: A1, A2, A3 is record 960. A1 has a date, A2 and A3 are 0's. The answer I am looking for would be "2". A8 and A9 is 522. The answer would be 1. In the end the final number I am looking for is the sum of 2 and 1, "3". A B 1 960 7/22/2004 2 960 0 3 960 0 4 967 0 5 990 8/7/2008 6 12 2/6/2007 7 43 10/16/2008 8 522 8/29/2008 9 522 0 10 174 2/28/2007 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
COUNT QUESTION | Excel Discussion (Misc queries) | |||
count question | Excel Discussion (Misc queries) | |||
Count question | Excel Discussion (Misc queries) | |||
Count question | Excel Discussion (Misc queries) | |||
Count If question | Excel Discussion (Misc queries) |