Hello,
I am trying to sum all values in column 11 of range 'PAC GL MTD_YTD'!A9:M115... that match what is in cell A10. However, the formula only give me a result of what value in column 11 of row 9.
=SUM(VLOOKUP(A10,'PAC GL MTD_YTD'!A9:M115,12,FALSE))
What is wrong?
I am trying to sum all values in column 11 of range 'PAC GL MTD_YTD'!A9:M115... that match what is in cell A10. However, the formula only give me a result of what value in column 11 of row 9.
=SUM(VLOOKUP(A10,'PAC GL MTD_YTD'!A9:M115,12,FALSE))
What is wrong?