- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel
- 2004 May
- Count Question

Subject: | Count Question |

Posted by: | John (te…@test.com) |

Date: | Mon, 03 May 2004 |

I have a spreadsheet with over 6,000 rows of data. Column A lists a

category of which there are 8 possibilities. I know how to use =countif

to determine how many times a certain category appears. However, beside

column A is a column with dates. These dates indicate when a certain

entry was closed. If there is no date in column B then the entry, or

case, is still considered open. I need to have a count of each category

for the cases that are still open. I assume a nested formula is the

key, but I'm not clear on what that would be. Any help would be much

appreciated.

Example:

Column A Column B

Row 1 AAA 7/25/04

Row 2 BBB

Row 3 BBB 8/1/04

Row 4 AAA 9/1/04

In the example above, I need a formula that would tell me how many times

BBB appears without a date beside it.

Thanks so much,

John

- Re: Count Question posted by JE McGimpsey on Mon, 03 May 2004
- Re: Count Question posted by DDM on Mon, 3 May 2004