FirstWorldAnalyst
New Member
- Joined
- Apr 13, 2018
- Messages
- 2
Hi Everyone!
Long time lurker, first time poster. I'm hoping someone can shed some light on a problem I'm facing with a summary sheet.
I have a large set of data that includes: brands, employees (that may or may not work under multiple brands) and their commissions earned from each brand.
Ex:
<tbody>
</tbody>
I need to build a separate summary sheet for each brand and those employees totals earned under that specific brand.
Normally, I'd create a summary sheet with an employee name column & a payout column that uses a formula like:
=SUMIF(Names,A2,Commission), but that would just total all the commission amounts in my data sheet and not allow me to separate out the brands.
Any help/assistance would be greatly appreciated!
Long time lurker, first time poster. I'm hoping someone can shed some light on a problem I'm facing with a summary sheet.
I have a large set of data that includes: brands, employees (that may or may not work under multiple brands) and their commissions earned from each brand.
Ex:
| A | B | C |
| BarnMart | John | $4.88 |
| Stark Ind | Jill | $3.87 |
| SteinMart | John | $7.82 |
<tbody>
</tbody>
I need to build a separate summary sheet for each brand and those employees totals earned under that specific brand.
Normally, I'd create a summary sheet with an employee name column & a payout column that uses a formula like:
=SUMIF(Names,A2,Commission), but that would just total all the commission amounts in my data sheet and not allow me to separate out the brands.
Any help/assistance would be greatly appreciated!
