# Discussion on: The scope on Excel's counting functions

12

### Join the conversation!

View:
Show:
###### There are other ways to count....
Vthanki 18th Aug 2010
Another important function "COUNTIF" does give you specific string or number count which is more useful than COUNT or COUNTA.
Contributr
###### Absolutely!
ssharkins@... 18th Aug 2010
Yes, I haven't forgotten COUNTIF() -- I just think it deserves an entry all its own! Look for it soon! But, I probably should've said that in the blog -- thanks for bringing it up!
###### Might also bring this up -
ragdyer@... 19th Aug 2010
XL's (terminology) inconsistency:

Enter
=""
in A1

In B1 enter
=Countblank(A1)

And in C1 enter
=Isblank(A1)

Might be a little confusing ...

Regards,
RD
###### COUNTIFS
One more function is countifs. Only difference with countif is it takes care of multiple conditions.
###### Also, the versatility of SUMPRODUCT
Hawklord99 19th Aug 2010
Can't take any credit for this one, but John Franco at:

Opened my eyes with "The Excel SUMPRODUCT Quick Start Guide" which demonstrates not only COUNT functions but SUMs, etc. also using SUMPRODUCT
###### RE: The scope on Excel's counting functions
cralph@... Updated - 18th Aug 2010
You forgot one, COUNTIF([range],[test value]). Great for counting the number of a specific value (text or number) that occurs in a range of cells.

(edited: Damn, didn't see the above comment until after I'd posted)
###### Count Functions
stapleb Updated - 19th Aug 2010
I show people how to use COUNT, COUNTA and COUNTBLANK. I know COUNTA and COUNTBLANK give the correct response, but one that the user may not believe. If someone has entered a space into a cell, it does not show, but will be included in the COUNTA and left out in the COUNTBLANK. To our eyes the answer is not correct, but because of the space, the answers are absolutely right.
###### RE: The scope on Excel's counting functions
rcstan 19th Aug 2010
Did you intend SCOOP in lieu of SCOPE?
Contributr
###### No
ssharkins@... 19th Aug 2010
No, I meant scope, but does scoop make more sense? I was thinking more along the lines of discovery not mystery, but maybe scoop would be better?
###### You decide:
oldbaritone 19th Aug 2010
Scope: range of operation, as the scope of a logical operator

Scoop: information especially of immediate interest

Sounds more like the latter to me
Contributr
###### you win!
ssharkins@... 20th Aug 2010
Scoop it is!
###### RE: The scope on Excel's counting functions
ziffdavis@... 19th Aug 2010
Don't forget:

SUBTOTAL(function_num, ref1, ref2, ...)

Where Function_num = 2 for Count
and =3 for CountA

The Subtotal function is handy because it does NOT count data in hidden rows/columns, e.g. when you are using a Filter
Keyboard Shortcuts:
Prev
Next
Toggle
###### Join the conversation
Formatting +
BB Codes - Note: HTML is not supported in forums
• [b] Bold [/b]
• [i] Italic [/i]
• [u] Underline [/u]
• [s] Strikethrough [/s]
• [q] "Quote" [/q]
• [ol][*] 1. Ordered List [/ol]
• [ul][*] · Unordered List [/ul]
• [pre] Preformat [/pre]
• [quote] "Blockquote" [/quote]

Join the TechRepublic Community and join the conversation! Signing-up is free and quick, Do it now, we want to hear your opinion.