lookup data in table

[Gary]

I am having trouble getting a result from the table below.
I need to know how many of each Door Type and size which come from dropdown
lists and also send through a related price.



A B C D E

870 870 Readicote
720 PBAL 2
MIL 1
870 MIL 101
COLONIAL
720 1030 Readicote
870 Readicote


I need this to display as:
1/1030 Readicote
3/870 Readicote
1/720 Readicote
1/870 MIL 101
1/720 PBAL 2

Thanks in Advance.

 

[Gary''s Student]

Use a formula like:

=SUMPRODUCT(--(A1100=870)*(E1:E100="Readicote")) & "/" & 870 & "/" &
"Readicote"

for each combination of type & size