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)=""))
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)=""))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks