This one is driving me a bit nuts - what would be the most efficient formula to count the number of 22 specified cells that meet 4 criteria? I am using Google Sheets.
Cells: I6,K6,O6,Q6,U6,W6,AA6,AC6,AG6,AI6,AM6,AO6,AS6,AU6,AY6,BA6,BE6,BG6,BK6,BM6,BQ6,BS6
Criteria:
1. Is not blank
2. Does not contain a -
3. Does not contain a /
4. Does not contain a *
I've tried using the format below, but something's not right:
=COUNTIFS(INDIRECT({I6,K6,O6,Q6,U6,W6,AA6,AC6,AG6,AI6,AM6,AO6,AS6,AU6,AY6,BA6,BE6,BG6,BK6,BM6,BQ6,BS6}),"<>*-*",INDIRECT({I6,K6,O6,Q6,U6,W6,AA6,AC6,AG6,AI6,AM6,AO6,AS6,AU6,AY6,BA6,BE6,BG6,BK6,BM6,BQ6,BS6}),"<>*/*",INDIRECT({I6,K6,O6,Q6,U6,W6,AA6,AC6,AG6,AI6,AM6,AO6,AS6,AU6,AY6,BA6,BE6,BG6,BK6,BM6,BQ6,BS6}),"<>*~**")
Thanks for any help with this!
Bookmarks