You could try COUNTIF instead:
=COUNTIF(F2:F10,1)
Or if you have multiple non-blank values maybe:
=COUNTA(F2:F10)-COUNTIF(F2:F10,"")
You could try COUNTIF instead:
=COUNTIF(F2:F10,1)
Or if you have multiple non-blank values maybe:
=COUNTA(F2:F10)-COUNTIF(F2:F10,"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks