Mitch Swetsky
asked on
Excel I need the Sum from a data sheet based on matching specific cells on current sheet
I have a data worksheet (Name=P01ytd) and a display sheet (Name=Dashboard (FY))
On the display sheet I have a variable number of rows with unique values in Col A.
I need to get the sum of the P01ytd Col AL where Dashboard (FY) Col A matches P01ytd Col X
I was using this vlookup ( =VLOOKUP(A12,P01Ytd!$X$1:$ AL$160,15, FALSE) ) to get the individual numbers BUT now I need the sum of all rows with values A12 to A whatever. I have a variable that I can use to replace "A whatever"
Can someone help?
On the display sheet I have a variable number of rows with unique values in Col A.
I need to get the sum of the P01ytd Col AL where Dashboard (FY) Col A matches P01ytd Col X
I was using this vlookup ( =VLOOKUP(A12,P01Ytd!$X$1:$
Can someone help?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks, with your suggestions, I realized that I could just sum the active cells in the column with no reference to the data sheet.
ASKER
I have attached a sample book with a display sheet and a P01ytd sheet
On the display sheet I need J1 to be the sum of the J rows below
Column A on Display will match Col X on the P01ytd sheet.
Book1.xls