Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
Use CountIF with conditional formulas | Excel Worksheet Functions | |||
Countif - Countif | Excel Worksheet Functions | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions | |||
combining countif formulas | Excel Worksheet Functions |