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

question by: Matt Callo

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/XjXbdf9EHnU;context-place=mydiscussions

Need IF function help - If value falls between two numbers

Jambs TOTAL:	2410 ft	Headers TOTAL:	990 ft	Sills TOTAL:	990 ft
Length	Qty.	Length	Qty.	Length	Qty.
6 ft	120	8 ft	60	8	60
6 ft	162	4 ft	81	4	81
8 ft	68	3.5 ft	34	3.5	34
4.25 ft	10	8 ft	5	8	5
8 ft	4	3.5 ft	2	3.5	2
12 ft	2	18 ft	1	18	1
13.5 ft	2	4 ft	1	4	1
14 ft	2	8 ft	1	8	1

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.