LinkBack URL
About LinkBacks
Many blank cells are found!
Anyway, try again with array formula:
Confirmed with ctrl-shift-enter
=SUMPRODUCT(IF(COUNTIF(A3:A35,A3:A35)=0,"",1/COUNTIF(A3:A35,A3:A35)))+COUNTIF(A3:A35,"E-MAIL")-1
Many blank cells are found!
Anyway, try again with array formula:
Confirmed with ctrl-shift-enter=SUMPRODUCT(IF(COUNTIF(A3:A35,A3:A35)=0,"",1/COUNTIF(A3:A35,A3:A35)))+COUNTIF(A3:A35,"E-MAIL")-1
Quang PT
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks