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?
>Solution :
Put it in C7 and drag to D7:E7
=SUMPRODUCT($B3:$B6,C3:C6)
Reference:
SUMPRODUCT