LinkBack URL
About LinkBacks
You can use COUNTIF in a 2 dimensional array:
Formula:
=COUNTIF(B2:Z50,"Y")
or you can combine ranges:
Formula:=COUNTIF(B2:Z50,"Y")+COUNTIF(B51:M150,"Y")
You can use COUNTIF in a 2 dimensional array:
Formula:=COUNTIF(B2:Z50,"Y")
or you can combine ranges:
Formula:=COUNTIF(B2:Z50,"Y")+COUNTIF(B51:M150,"Y")
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks