Ryan,
=COUNTIF(B7:X11, "V") + COUNTIF(B15:X19,"V").....
HTH,
Bernie
MS Excel MVP
"ryanjh79" wrote in message
...
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
|