Using Cell Values to Reference another sheet

Hi, I am an amateur at excel, and it's quite possible that what I'm asking has a simple fix, or no fix at all. I am currently making a budget for myself and my wife. Each months respective ...

excel

Excel on Mac

Formulas and Functions

Haytham Amairah
Mar 03, 2019
Hi,

You need the https://support.office.com/en-us/article/indirect-function-474b3a3a-8a26-4f44-b491-92b6306fa261 function to do that.

Please try this formula in cell J4 and drag it down.
=SUMIF(INDIRECT(I4&"!$AK$7:$AK$23"),"<>Ending Balance",INDIRECT(I4&"!$AM$7:$AM$23"))

Hope that helps

Haytham Amairah

Silver Contributor

Mar 03, 2019

Hi,

You need the https://support.office.com/en-us/article/indirect-function-474b3a3a-8a26-4f44-b491-92b6306fa261 function to do that.

Please try this formula in cell J4 and drag it down.

=SUMIF(INDIRECT(I4&"!$AK$7:$AK$23"),"<>Ending Balance",INDIRECT(I4&"!$AM$7:$AM$23"))

Hope that helps

bostonsullivan

Copper Contributor

Mar 04, 2019

Thats perfect! thanks so much!

Forum Discussion

Using Cell Values to Reference another sheet