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.
If it's OK to make the amounts in Sheet1 column D unique, you can use the formula in the attached version. It divides the donation amount by the number of charities that contributed that amount.
Having 2000 occur twice caused problems with that.
- 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.
