I need to have a formula

[qtviet]

Can someone please help me? I need to have a condition in which you have to
read 3 columns and then make that into 2 different parts. Here is my problem
I need to know how much to cut or what lenght to use with a standard stiles
consists of lenght: 67, 72, 80, 88, 94, and 150

A B=butt C=rabbet D=height
Paint 2 2 80
Paint 2 0 72
Paint 2 2 88


From the sample above, I know that I would have to use (2) stiles from the
length 80 to cut for butt, and I need (2) stiles from 80 to cut for rabbet
for the 1st order.
On 2nd order I would need (2)stiles for lenght 72 to cut for the butt.

the whole thing will be just like this but I want to create a formula where
I don't have to read it over and over but instead just entered the # and it
would tell me how many stiles i would need to make the whole order.

Can this be possible to have it in the formula? please help me. Thanks

 

[T. Valko]

One way:

List the sizes available in a range of cells:

G2:G7 = 67, 72, 80, 88, 94, 150

Then enter this formula in H2 and copy down to H7:

=SUMIF(D$2$20,G2,C$2:C$20)+SUMIF(D$2$20,G2,B$2:B$20)