CountA question

A

Andrew

Hi there,

In cells R18 to R20 different text can be entered by users. I need to count
the number of cells with text (sometimes cells are blank so are not counted)
but also exclude certain possible text options which are listed in cells R941
ot R946. I currently have COUNTA(R18:R20) but am having trouble adding the
'excluding' part of the formulae. Can someone please help! Thank you.
 
A

Andrew

Thanks Bob, that is great :)

Bob Phillips said:
=SUMPRODUCT(--(R18:R20<>""),--(NOT(ISNUMBER(MATCH(R18:R20,R941:R946,0)))))

--
__________________________________
HTH

Bob
Click to expand...
 

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

Similar Threads

counta formula 4
Using COUNTA and excluding formulas that gives zero or blank cells 3
how to count this in this unusual situation 2
Using the COUNTA function 1
counta and or if 6
COUNTA Function 7
Counting Dates 3
CountIF or COUNTA for specific text 6

Top