View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Alexis
 
Posts: n/a
Default COUNTIF FORMULAS

USING THIS INFORMATION DIRECTLY BELOW..
If the weight of a Bag was under 49lbs it would be considered UNDER.
If the weight of a Bag was 49lbs to 50.99 it would be considered GOOD.
If the weight of a Bag was 51lbs or over it would be considered OVER.

My formula to find the number of saltbags that are under weight is
=COUNTIF(B4:B18,"<49")
My formula to find the number of saltbags that are over weight is
=COUNTIF(B4:B18,"=51")

HOW WOULD I WRITE THIS COUNTIF FORMULA????
What formula would i use to find the number of salt bags that are "Good"
weight?
how would i write 49 but <51??

ALSO.. then how would i find total weight of bags that are Under and Over
weight?
i know i would use =SUMIF(B5:B18, ... but then i dont know what i would
write for the criteria or sum_range?