Trim Range of Cells FIRST then Count the number of blank cells

[Jim28]

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

[:) Sixthsense :)]

May be simply try like this…

=SUMPRODUCT(1*(A1:C3=""))+SUMPRODUCT(1*(E1:F3=""))

[Jim28]

Thanks but it does not remove the spaces FIRST and then count the blanks cells

[:) Sixthsense :)]

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)=""))

[Jim28]

Very clever indeed. Many thanks!!!!!

[:) Sixthsense :)]

Glad it helps you and thanks for the feedback and rep