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,"BENE")
85% of the formulas are working, but the other 15 will add more to the count.
2 Replies
=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!!!!!
