Forum Discussion
Subtotals
I have a spreadsheet with a list of payments to employees per month. I have added subtotals but now I want to have only the subtotal rows to reflect so that I can read it into another spreadsheet w...
Hi
I attached a sample file for you.
In Sheet 1 there is a list of Employees and their Payment with a Subtotal created for each employee.
In Sheet 3 I created a Drop List to select the Employee Name and a VLOOKUP function to pick up the Subtotal from Sheet 1
=VLOOKUP(E1&" Total",Sheet1!$A$1:$C$24,3,0)
Hope that Helps
Nabil Mourad