mrsbrannon
Board Regular
- Joined
- Mar 7, 2018
- Messages
- 61
Hello everyone!
I am in need of two formulas that could possibly be the same/similar. See sample tables below:
<tbody>
</tbody>
My spreadsheet has many more columns than this and the data is spread throughout it, but this is just for quick use purposes. I need a formula that will do the following:
NEXT
<tbody>
</tbody>
I need the formula to do the following:
All help is greatly appreciated!!
P.S. Please note, this info is on two different spreadsheets and cannot be combined.
I am in need of two formulas that could possibly be the same/similar. See sample tables below:
Name | Title | Hours | Helper Column? |
June Carter Cash | Singer | 1.33 | 1.83 |
June Carter Cash | Manager | 1.67 | 1.67 |
Hank Williams | Singer | .20 | .70 |
Hank Williams | Songwriter | 1.50 | 4 |
June Carter Cash | Singer | .50 | |
Hank Williams | Songwriter | 2.5 |
<tbody>
</tbody>
My spreadsheet has many more columns than this and the data is spread throughout it, but this is just for quick use purposes. I need a formula that will do the following:
- Find each person
- Find their title(s)
- SUM up the total hours worked PER TITLE, PER PERSON
NEXT
Name | Title | Billable Amount | Pay Out | Profit |
June Carter Cash | Singer | $45.00 | $120.00 | $25.00 |
June Carter Cash | Manager | $100.00 | ||
Hank Williams | Singer | $50.00 | $175.00 | $75.00 |
Hank Williams | Songwriter | $200.00 |
<tbody>
</tbody>
I need the formula to do the following:
- Find the person
- Find the title(s)
- Add up the Billable Amount PER PERSON (include all titles)
- Subtract the Pay-Out
- Return the Profit
All help is greatly appreciated!!
P.S. Please note, this info is on two different spreadsheets and cannot be combined.
Last edited: