ExcelBanter - something wrong with my "countif" function

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - something wrong with my "countif" function (https://www.excelbanter.com/excel-discussion-misc-queries/2135-something-wrong-my-%22countif%22-function.html)

ryanjh79

something wrong with my "countif" function

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.

--
Regards
Frank Kabel
Frankfurt, Germany
"ryanjh79" schrieb im Newsbeitrag
...
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

Bernie Deitrick

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

Peo Sjoblom

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

All times are GMT +1. The time now is 06:20 PM.