Forum Discussion
Solved
Modification to SUMIFS INDEX - Help please
Hi everyone I am hoping if someone could help/advise with this fiddly problem I'm having on the attached. I have a formula in Sheet2 which is very effectively tracking fictitious donations based ...
Yeah, OK, that complicates things (and that's why it's always better to provide a realistic example at the outset instead of adding complexity step by step).
New version attached. I added a helper column to Sheet1.
Thank You Hans, I could perhaps use this approach as a workaround. However I have noticed that when a new donation value is added under the same column, the figure reverts to zero.
Please provide an example.
- So if a new donation figure is added in column D and a charity selected which already has a checkmark under it, Charity 1 for example, the figure in the Sheet2 formula corresponding the Charity 1 now reads as 0 for me.
Appreciate your help.Yeah, OK, that complicates things (and that's why it's always better to provide a realistic example at the outset instead of adding complexity step by step).
New version attached. I added a helper column to Sheet1.
- Thanks so much Hans. This is really helpful.