Hi,
Is there a possibility to change the input range for the formula if you change the sheetname in a dropdown list.
If I select 'Sheet1', the sumif formula calculates with the data in sheet 1.
If I select 'Sheet2', the sumif formula calculates with the data in sheet 2.
If possible, no macro-code.
File with example attached.
thx
J
You can do that with INDIRECT.
Try
=SUMIF(INDIRECT("'"&$I$4&"'!F7:F16"),E9,INDIRECT("'"&$I$4&"'!G7:G16"))
jonas:
Large:Formula:
Please Login or Register to view this content.
Small:Formula:Please Login or Register to view this content.
Intermediate:Formula:Please Login or Register to view this content.
Indirect lets you make a cell value part of the formula.
One note: you didn't have "$" in your second half of the formulas, so when copied down you will see the rows went from G7:G16 to G8:G17 to G9:G18. I didn't change that, but if it was in error then don't forget to fix that
Last edited by Arkadi; 06-08-2018 at 08:26 AM.
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
Great man!
Thanks!
I had found in on the internet as well, but couldn't figure it out
You're welcome.
jonas-martens, please take a moment to mark the thread as solved if the issue is resolved? Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks