Formula with to Criteria

  • Thread starter Thread starter Glenn
  • Start date Start date
G

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
 
=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
 
Back
Top