Formula with to Criteria

[Glenn]

Hi,
I have a row of numbers in Coloumn B ranging from 1 to 200 what I want is a
formula in cell A1 that will do the folowing.

Look at my range in coloumn b for example B1:B200 and countif the number is
the coloumn is over 25 >25 and below 100 <100.
I can do countif functions but don't know who to do the above or below part.

Any help would be apperciated

Thanks

 

[Bernard Liengme]

=COUNTIF(B1:B200,">25")-COUNTIF(B1:B200,">=100")
OR
=SUMPRODUCT(--(B1:B200>25),--(B1:B200,>=100))
OR, in Excel2007+ only
=COUNTIFS(B1:B200,">25",B1:B200,">=100")

best wishes

 

[T. Valko]

One way...

over 25 >25 and below 100 <100.

=COUNTIF(B1:B200,">25")-COUNTIF(B1:B200,">=100")