COUNTIF does not work over multiple ranges, you need to use
=SUM(COUNTIF(B7:X11,"V"),COUNTIF(B15:X19,"V"),and so on)
Regards,
Peo Sjoblom
"ryanjh79" wrote:
why won't this function work with multiple ranges?
=COUNTIF(B7:X11,B15:X19,B23:X27,B31:X35, "V")
I need to check info in different places on the worksheet
Thanks,
Brandon
|