Subtotals/sums based on criteria in multiple columns

[pcaldwell]

I need to keep a running total of $ and Jobs per piece of equipment. Some jobs use multiple pieces of equipment. If that's the case I can just divide it equally. Jobs are added daily onto separate monthly sheets. Ideally would like running total to appear on one "Summary" worksheet.

[Zodeeak]

Try the attached.

Hope that helps.

-Z