Hello,
I am searching for a formula which combines an indirect function with a sumif function. So my sheet can automatically collect information from differents sheets according specific days.
I already have an working indirect function but the combination with sumif does not work.
See the added example,
Thanks in advance
In D4 Cell of Dash pr sheet
=SUMIF(INDIRECT("'"&C4&"'!B1:B100"),D2,INDIRECT("'"&C4&"'!C1:C100"))
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Do you absolutely need to use one sheet a day? Why not use one sheet, adding a day column. Starting from there, it's much much easier
Solution works fine, thanks
I noticed that I was close to the solution myself, but your formula definitely helps!
@Pepe Le Mokko: The example is a strong simpliciation.
I have a lot more workfiles with sheets containing huge amount of data. When my dashboard depends on specified parameters I can easily copy it to other workfiles.
Vincent
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks