Is there a function or a way of structuring a formula to best find the results of C7, D7 and E7.

These cells need to show the rate x hours for every person on the job.

What I normally do is (for C7):

=(B3xC3) (B4xC4) (B5xC5) (B6xC6)

This can become very long and cumbersome when there are lots of people. Is there a simpler way?

CodePudding user response：

Put it in C7 and drag to D7:E7

=SUMPRODUCT($B3:$B6,C3:C6)

Reference: