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?