Formula help with countif

[mrrick]

I have a spreadsheet for ordering lengths of frames. The frame lengths are in seven different lengths. I use the countif formula to identify the quantity ordered of each size. This part I'm ok with. The frames are ordered with two different finishes. Part A is one finish and Part B is another finish. So one aspect of the spreadsheet counts the total number of specific lengths and the other aspect I'm trying to figure out is how to identify the breakdown of Part A and Part B.
Here is an example where quantities ordered in column A are one finish and quantities ordered in column B are another finish. Columns C and D are the various lengths required:

A B C D
1 0 18 24
0 1 18 24
0 2 24 84
1 0 24 84
(I've added zeros just to keep the spacing accurate)

I use COUNTIF(C2:D5,"18") to identify the number of 18" lengths and COUNTIF(C2:D5,"24") to identify the number of 24" lengths and so on for the different sizes.
How do I take into account multiples ordered, like the qty of 2 24x84 frame lengths?
How do I then break out from the totals the number of Part A finish and Part B finish.

Thank you for any guidance you can give me. I can make a sample spreadsheet available if needed.

 

[jbeaucaire]

A SUMPRODUCT() formula can be used for this.

Excel Workbook
	A	B	C	D	E	F	G	H	I	J
1	A	B	C	D				18	24
2	1	0	18	24			A	1	1
3	0	1	18	24			B	1	2
4	0	2	24	84
5	1	0	24	84
6
7
8
Sheet4

 

[mrrick]

Thank you very much, that was exactly what I needed. I appreciate your help!