Count if multiple criteria in excel 97

[Paul Naylor]

Hi Trying to fing a formula that will count using multiple criteria.( Excel 97)

I've got 2 column F2: & G365 which can contain values between 0-10. Need a formula which counts cells where values are between 4-7

 

[Michael M]

Try...adjust ranges to suit

=COUNTIFS(F2:F365,">=4", BG2:G365,"<=7")

 

[Marcelo Branco]

Maybe..

=COUNTIF(F2:G365,">=4")-COUNTIF(F2:G365,">7")

M.

 

[Peter_SSs]

Try...adjust ranges to suit

=COUNTIFS(F2:F365,">=4", BG2:G365,"<=7")

COUNTIFS with Excel 97??


(Don't remember when COUNTIF started?)

 

[Fluff]

Another option

=SUMPRODUCT((F2:G365>=4)*(F2:G365<=7))

 

[Michael M]

COUNTIFS with Excel 97??


(Don't remember when COUNTIF started?)

Yep ...got me ...didn't even think about that...

 

[Paul Naylor]

Maybe..

=COUNTIF(F2:G365,">=4")-COUNTIF(F2:G365,">7")

M.

Thanks Marcelo. Completely forgot about 7s8ng a Venn diagram approach for excel 97 version.

 

[Marcelo Branco]

You're welcome. Glad to help.

M.