Forum Discussion
having an issue with a COUNTIF counting malfunction
I was using a formula as such to try to get all my counts together of each of the tables on my sheet: =COUNTIF(H3:H83,"BENE") +COUNTIF(Q3:Q13,"BENE") +COUNTIF(R20:R58,"BENE")+COUNTIF(H64:H83,"BEN...
=COUNTIF(H3:H83,"BENE") +COUNTIF(Q3:Q13,"BENE") +COUNTIF(R20:R58,"BENE")+COUNTIF(H64:H83,"BENE")
Is this perhaps because range H64:H83 is included in range H3:H83?
wow,, i didn't even realize... thanks for the help!!!!!