Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
CountA problem
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) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
CountA problem
One way:
=SUMPRODUCT(--(E3:E148<"d"),--(E3:E148<"")) HTH, Paul -- "Jim" wrote in message ... 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) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
CountA problem
Hi,
Try =COUNTIF(E3:E148,"<E") -- Cheers, Shane Devenshire "Jim" wrote: 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) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
CountA problem
=COUNTA(E3:E143)-COUNTIF(E3:E143,"D")
will exclude both upper and lower case d -- Gary''s Student - gsnu200765 "Jim" wrote: 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) |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
CountA problem
Change the E to a D, it handles both upper and lower case.
-- Cheers, Shane Devenshire "ShaneDevenshire" wrote: Hi, Try =COUNTIF(E3:E148,"<E") -- Cheers, Shane Devenshire "Jim" wrote: 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) |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
CountA problem
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 -- "ShaneDevenshire" wrote in message ... Change the E to a D, it handles both upper and lower case. -- Cheers, Shane Devenshire "ShaneDevenshire" wrote: Hi, Try =COUNTIF(E3:E148,"<E") -- Cheers, Shane Devenshire "Jim" wrote: 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) |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
CountA problem
I really need to use COUNTA,
thanks for your help so far. Jim "Jim" wrote in message ... 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) |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
CountA problem
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 -- "Jim" wrote in message ... I really need to use COUNTA, thanks for your help so far. Jim "Jim" wrote in message ... 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) |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
CountA problem
Hello Paul,
Got it sorted now. Many thanks Jim "Jim" <jim. wrote in message ... 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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTA() | Excel Discussion (Misc queries) | |||
Counta | New Users to Excel | |||
COUNTA | Excel Worksheet Functions | |||
counta | Excel Worksheet Functions | |||
COUNTA Function not working =COUNTA(C3:C69,"NH") | Excel Worksheet Functions |