Forum Discussion
Solved
IFS Compatibility Issues with Older Excel Versions
I created a tool to run some tests. I use Microsoft 365, and some of the functions I used in my tool are apparently new. The users of my tool have older versions of excel, and they encountered #NAME ...
There was a mistake in the original SUMPRODUCT formula. Thank you for pointing this out.
Wow, thanks! Yes, that does seem to work pretty well. There's an issue if there's a tie, though. Example: if school C and D had the same low income percent, they both get the rank of 2 with SUMPRODUCT vs 1 with COUNTIFS. Wonder if there's a solution.
| School | Type | Grade Span | % Low Income | District-Wide Rank | Grade-Span Rank | |
| School A | Elementary | P-8 | 77 | 9 | 1 | 1 |
| School B | High | 9-12 | 75 | 10 | 3 | 3 |
| School C | High | 9-12 | 88 | 4 | 1 | 2 |
| School D | High | 9-12 | 88 | 4 | 1 | 2 |
There was a mistake in the original SUMPRODUCT formula. Thank you for pointing this out.
Ah yes, the same +1 solution as with the COUNTIFS formula I had. Thanks very much for the help!