Forum Discussion
Help with MAXIFS with multiple criteria across multiple sheets
Hello, I am trying to get the highest value from one identical column across multiple sheets, based on multiple criteria (highest number of beneficiaries reached by any one activity within a spec...
If your formula
=SUMPRODUCT(SUMIFS(INDIRECT(...
works, copy/paste it as it is, and change on
=MAX(MAXIFS(INDIRECT(...
Thus you'll be sure there are no other errors in the formula
SergeiBaklan Thank you for the suggestion!
For some reason, that approach works with other formulas, ex:
=SUMPRODUCT(MAXIFS(INDIRECT
returns an accurate value. However, when I use the same approach with
=MAX(MAXIFS(
it consistently returns #VALUE!
Do you have any other suggestions by any chance?