J
Jim
I am using the formula as shown below, but I want to exclude the letter D or
d
from the count, any ideas?
Thanks
Jim
=COUNTA(E3:E148)
d
from the count, any ideas?
Thanks
Jim
=COUNTA(E3:E148)
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
PCLIVE
One way:
=SUMPRODUCT(--(E3:E148<>"d"),--(E3:E148<>""))
HTH,
Paul
=SUMPRODUCT(--(E3:E148<>"d"),--(E3:E148<>""))
HTH,
Paul
S
ShaneDevenshire
Hi,
Try =COUNTIF(E3:E148,"<>E")
Try =COUNTIF(E3:E148,"<>E")
G
Gary''s Student
=COUNTA(E3:E143)-COUNTIF(E3:E143,"D")
will exclude both upper and lower case d
will exclude both upper and lower case d
S
ShaneDevenshire
Change the E to a D, it handles both upper and lower case.
P
PCLIVE
Your formula will count anything that is not "D". COUNTA was the original
formula which counts non-blanks. I assuming the OP wants to count all
non-blank cells that are NOT "E".
Either mine or Gary"s Student's suggestion should do the trick.
=SUMPRODUCT(--(E3:E148<>"d"),--(E3:E148<>""))
=COUNTA(E3:E143)-COUNTIF(E3:E143,"D")
Regards,
Paul
--
formula which counts non-blanks. I assuming the OP wants to count all
non-blank cells that are NOT "E".
Either mine or Gary"s Student's suggestion should do the trick.
=SUMPRODUCT(--(E3:E148<>"d"),--(E3:E148<>""))
=COUNTA(E3:E143)-COUNTIF(E3:E143,"D")
Regards,
Paul
--
J
Jim
I really need to use COUNTA,
thanks for your help so far.
Jim
thanks for your help so far.
Jim
P
PCLIVE
You've been given a couple of suggestions that work, including one that uses
COUNTA. Did they not work? You may need to elaborate on what you're trying
to do.
Regards,
Paul
--
COUNTA. Did they not work? You may need to elaborate on what you're trying
to do.
Regards,
Paul
--
J
Jim
Hello Paul,
Got it sorted now.
Many thanks
Jim
Got it sorted now.
Many thanks
Jim