Hi everyone
As title says, im trying to count cells in an area that are not empty, but it should not include cells with formulas resulting in blanks in form of "". So in an area with for instance 5 cells with normal text, 20 empty cells, 2 cells with formulas resulting in "" and 4 cells with formulas resulting in text, the fomula im looking for should say 9.
Really hope someone got an solution for this and thanks in advance
=count(a1:a100)+countif(a1:a100,"?*")
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Try in this way...
=SUMPRODUCT(--(A1:A10<>""))
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
So you're just counting non-empty cells.
=COUNTA(A1:A100)
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Hi.
Since you mention only text, not numbers:
=COUNTIF(Range,"?*")
If in fact there may also be numbers present which you would also wish to be included in the count:
=SUMPRODUCT(0+(LEN(Range)>0))
Regards
That counts null strings "", which the OP specifically asked not to be considered.Originally Posted by Special-K
Regards
Nice. If numbers are also to be considered then, over large ranges, this should be more efficient that the SUMPRODUCT constructions given in this post, despite the fact that two COUNTIF functions are being used.
Regards
Both solutions works just as intended - thanks to both of you for the very fast replies
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks