View Single Post
  #3   Report Post  
Bernie Deitrick
 
Posts: n/a
Default

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