bearcub
Well-known Member
- Joined
- May 18, 2005
- Messages
- 731
- Office Version
- 365
- 2013
- 2010
- 2007
- Platform
- Windows
I am using the following 2 formulas to create a table that summarizes commissions that are being paid. I would like make the table dynamic so I do have a number of blank rows below the data. Right now I have to insert blank rows to account an expanding table.
Also, I am getting a weird Total Value after the last table row.
I am using the unique function to spill the people being paid this month and the following formula to add all the orders that should be paid to them
List all the people being paid this month:
IF(UNIQUE(Table6[Rep Name])="","",UNIQUE(Table6[Rep Name]))
Add all the orders on this sheets:
BYROW(Q6#,LAMBDA(r,SUMIF(A:A,r,B:B)))
Is there a way to create a formula that perform both of these and create a dynamic "Total" row that expands and contracts with the # of people being paid:
Here is the table that I am referring to in column P & Q. The third column is reconcile the names on the summary sheet going to payroll.
Also, I am getting a weird Total Value after the last table row.
I am using the unique function to spill the people being paid this month and the following formula to add all the orders that should be paid to them
List all the people being paid this month:
IF(UNIQUE(Table6[Rep Name])="","",UNIQUE(Table6[Rep Name]))
Add all the orders on this sheets:
BYROW(Q6#,LAMBDA(r,SUMIF(A:A,r,B:B)))
Is there a way to create a formula that perform both of these and create a dynamic "Total" row that expands and contracts with the # of people being paid:
Here is the table that I am referring to in column P & Q. The third column is reconcile the names on the summary sheet going to payroll.