Hi,
I've got a SUMIF formula that looks over a range called 'Budget_Values' but i'd like to be able to switch it to a range called 'Forecast_Values' based on a drop down menu (the only two options are 'Budget' and 'Forecast') in cell A1.
How would I incorporate the INDIRECT function to achieve this? I've tried a couple of different ways but I keep hitting Error City, Arizona
Current formula:
=SUMIF(Budget_Values
Required formula:
=SUMIF(INDIRECT(?
Thanks,
Snook
Last edited by The_Snook; 10-18-2012 at 06:40 AM.
Ηι
See if this helps you.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Sorry Fotis1991, it doesn't resolve my query. I've replicated a smaller version of my problem on the attached spreadsheet.
Regards,
Snook
Hi Snook.
Only 2 sheets and in the same columns are your data in your real workbook?
=SUMIF(INDIRECT(INDIRECT("a1")&"_Product");A12;INDIRECT(INDIRECT("a1")&"_Values"))
Here is your formula. Paste it to the first required cell
Eisayew is in the right ball park for what i'm trying to achieve but unfortunately i'm getting an error message when I try to copy and paste it?!?!
Any suggestions?
This is what you need in B12:
=SUMIF(INDIRECT(A$1&"_Product"),A12,INDIRECT(A$1&"_Values"))
Hope this helps.
Pete
Try to replace semicolons ";" with commasOriginally Posted by The_Snook
Eisayew is in the right ball park for what i'm trying to achieve but unfortunately i'm getting an error message when I try to copy and paste it?!?!
Any suggestions?
Pete me auld mucker it looks like you've nailed it brother
Fotis1991 and eisayew thanks for trying to assist me
You are welcome Snook, but..
Yes. I just tried to help you BUT eisayew's formula works great. So good as Pete's formula.
And as eisayew, is a new member here, a big Congr
Thank you very much for welcomming,You are welcome Snook, but..
Yes. I just tried to help you BUT eisayew's formula works great. So good as Pete's formula.
And as eisayew, is a new member here, a big Congr
It is really good motivation for in my first day here
I hope I will learn much in this forum,
Good luck to you and everyone
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks