Discussion on:
View:
Show:
Another important function "COUNTIF" does give you specific string or number count which is more useful than COUNT or COUNTA.
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!
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
Enter
=""
in A1
In B1 enter
=Countblank(A1)
And in C1 enter
=Isblank(A1)
Might be a little confusing ...
Regards,
RD
One more function is countifs. Only difference with countif is it takes care of multiple conditions.
Can't take any credit for this one, but John Franco at:
www.Excel-Spreadsheet-Authors.com
Opened my eyes with "The Excel SUMPRODUCT Quick Start Guide" which demonstrates not only COUNT functions but SUMs, etc. also using SUMPRODUCT
www.Excel-Spreadsheet-Authors.com
Opened my eyes with "The Excel SUMPRODUCT Quick Start Guide" which demonstrates not only COUNT functions but SUMs, etc. also using SUMPRODUCT
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)
(edited: Damn, didn't see the above comment until after I'd posted)
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.
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?
Scope: range of operation, as the scope of a logical operator
Scoop: information especially of immediate interest
Sounds more like the latter to me
Scoop: information especially of immediate interest
Sounds more like the latter to me
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
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
