I have a spreadsheet for ordering TShirts of various sizes. In the G Column, I only want to tally (count) the cells that have text data (not blanks) as long as the text is NOT "NO".
I don't know how to do a counta with an if... or even if that is possible. The count function is that counts ALL non blank cells is =COUNTA(G2:G42) .. but this counts the cell containing "NO" as well. ThAnKs!
Thanks!
I don't know how to do a counta with an if... or even if that is possible. The count function is that counts ALL non blank cells is =COUNTA(G2:G42) .. but this counts the cell containing "NO" as well. ThAnKs!
Thanks!