G
Guest
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?
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?