LinkBack URL
About LinkBacks
Dear all
I want to be able to remove any invisable spaces in cells within a range (say "A1:C3" and "E1:F3") and THEN count the number of blank cells.
Is there a simply way of doing this?
Thanks.
James
Dear all
I want to be able to remove any invisable spaces in cells within a range (say "A1:C3" and "E1:F3") and THEN count the number of blank cells.
Is there a simply way of doing this?
Thanks.
James
May be simply try like this…
=SUMPRODUCT(1*(A1:C3=""))+SUMPRODUCT(1*(E1:F3=""))
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
Thanks but it does not remove the spaces FIRST and then count the blanks cells
If your ultimate goal is to get the Blank cells count then try the below formula now added a trim function to it.
=SUMPRODUCT(1*(TRIM(A1:C3)=""))+SUMPRODUCT(1*(TRIM(E1:F3)=""))
Very clever indeed. Many thanks!!!!!
Glad it helps you and thanks for the feedback and rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks