Forum Discussion

J9steyn's avatar
J9steyn
Copper Contributor
Oct 20, 2019

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 with VLOOKUP.  It will take forever to delete the other info and I will first need to copy and paste the subtotal rows as values....  please help !

excel

1 Reply

  • nabilmourad's avatar
    nabilmourad
    MVP
    Oct 20, 2019

    J9steyn 

    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

Resources