Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I Need Help with COUNTA and/or SUMPRODUCT
Experts, I have this situation:
A B ITEM DONE 1 ABC April 2 XYZ January 3 XYZ 4 ABC May 5 ABC I want to know how many "ABC" have been completed; in other words, how many "ABC" have non-blank cells in column B. The answer should be 2. Which formula should I use. COUNTA, DCOUNTA or SUMPRODUCT? I'm sorry for the silly question. Thanks a lot in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counta | Excel Worksheet Functions | |||
Counta | New Users to Excel | |||
COUNTA | Excel Worksheet Functions | |||
using COUNTA | Excel Discussion (Misc queries) | |||
COUNTA Function not working =COUNTA(C3:C69,"NH") | Excel Worksheet Functions |