Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
CountA question
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
CountA question
=SUMPRODUCT(--(R18:R20<""),--(NOT(ISNUMBER(MATCH(R18:R20,R941:R946,0)))))
-- __________________________________ HTH Bob "Andrew" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
CountA question
Thanks Bob, that is great :)
"Bob Phillips" wrote: =SUMPRODUCT(--(R18:R20<""),--(NOT(ISNUMBER(MATCH(R18:R20,R941:R946,0))))) -- __________________________________ HTH Bob "Andrew" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTA Conditional Formating question | Excel Discussion (Misc queries) | |||
Counta function question | Excel Worksheet Functions | |||
using COUNTA | Excel Discussion (Misc queries) | |||
counta | Excel Discussion (Misc queries) | |||
COUNTA Function not working =COUNTA(C3:C69,"NH") | Excel Worksheet Functions |