I am trying to create a summary table of expenses for a massive project for 35 people (each assigned a "type"). My data set is:
<tbody>
</tbody>
My summary table is:
<tbody>
</tbody>
The hotel and Per Diem are easily done with sumifs(). I'm running into an issue with the types because each type has to have the individual row calculated then totaled.
It would be something like sum( (b2*8)*c2), (b3*8)*c3), etc. ) but I don't want to hard code it - more are being added everyday, so I'd like to have a simple formula to find, calculate and add everything.
Thanks for any ideas.
Josh
Type | Pay Rate | Days | Hotel | Per Diem | total |
1099 | 15.00 | 15 | 0 | 50 | =((pay*8)*days)+hotel+per diem -- $1850 |
1099 | 18.00 | 20 | 500 | 50 | $3430 |
Internal | 35.00 | 10 | 200 | 50 | $3050 |
Vendor | 100.00 | 10 | 0 | 50 | ..... |
<tbody>
</tbody>
My summary table is:
Type | Pay | Hotel | Per Diem | Total |
1099 | $5280 | sumifs() | sumifs() | sum(b2:d2) |
Internal | ||||
Vendor | ||||
<tbody>
</tbody>
The hotel and Per Diem are easily done with sumifs(). I'm running into an issue with the types because each type has to have the individual row calculated then totaled.
It would be something like sum( (b2*8)*c2), (b3*8)*c3), etc. ) but I don't want to hard code it - more are being added everyday, so I'd like to have a simple formula to find, calculate and add everything.
Thanks for any ideas.
Josh