Wednesday, December 13, 2017

yogi_Material TakeOff Computation From Item Length and Quantity Table

Google Spreadsheet   Post  #2320

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Dec-13-2017
Need IF function help - If value falls between two numbers

Jambs TOTAL:2410 ftHeaders TOTAL:990 ftSills TOTAL:990 ft
LengthQty.LengthQty.LengthQty.
6 ft1208 ft60860
6 ft1624 ft81481
8 ft683.5 ft343.534
4.25 ft108 ft585
8 ft43.5 ft23.52
12 ft218 ft1181
13.5 ft24 ft141
14 ft28 ft181

I have three sets of cells that as seen above, one for Window Jambs, one for Window Headers, and one for Window Jambs. Next to each ft you'll see a number of quantity (i.e. 6ft. and 120 mean there are 120 6ft. Jambs on one type of window, 162 6ft. Jambs of another). 

I want to create an IF function that if, say, a number falls equal 6, the qty numbers associated will be added so I'll know how many 6ft. lengths I have. Same thing for if it's less than or equal to 4 ft. This way I can figure out how many 10' lengths I'll need and can fit a 6' Jamb with a 4' Header or 3.5' Sill. 

I want to similar functions for the other numbers as well, but if someone can start me here, that would be appreciated.  

Thanks.