| 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 | |||
![Jim[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
