Formula:Please Login or Register to view this content.
I have the above IF statement that returns a unique string if true, and returns "" if false so the cell is blank.
I want to count the cells that contain a TRUE value output. My thought was to subtract the =COUNTA output from the total # cells, but since all cells contain an IF statement, =COUNTA won't work. I thought about =COUNTIF, but the strings are all unique, so that wouldn't work either.
What is the workaround?
Hoping for a non-VBA solution.
Thanks in Advance!
Bookmarks