I Need Help with COUNTA and/or SUMPRODUCT

O

Oskar

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.
 
B

Bob Phillips

=SUMPRODUCT(--(A1:A5="ABC"),--(B1:B5<>""))

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
P

Pete_UK

Not a silly question. Try this:

=SUMPRODUCT((A1:A5="ABC")*(B1:B5<>""))

Hope this helps.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top