something wrong with my "countif" function

[Guest]

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

 

[Frank Kabel]

Hi
see your other posts.

 

[Bernie Deitrick]

Ryan,

=COUNTIF(B7:X11, "V") + COUNTIF(B15:X19,"V").....

HTH,
Bernie
MS Excel MVP

 

[Guest]

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