# Sum Products that meet a criteria

Posted by Eric on October 30, 2001 10:02 AM

With the following data:

A B C D E

1 Labor Material Percentage Labor Material

2 1000 2100 10% 100 210

3 900 1900 0% 0 0

4 800 2000 80% 640 1600

5 1000 2200 35% 350 770

6 1090 2580

7 Labor 1,090

8 Material 2,580

Is there a way to arrive at the values in C7 and C8 without adding the formulas in columns D and E? I've tried a variety of CSE formulas including combinations of SUM and PRODUCT, but no luck. Obviously my real spreadsheet contains much more data than this.