Maximum number of arrays to use with SUMIFS

Take this:

1. Use Multiple SUMIFS and Add Them

=SUM(
  SUMIFS(DATA[Eligibility], DATA[Location], "A", DATA[SchoolType], "D", DATA[Program], "X"),
  SUMIFS(DATA[Eligibility], DATA[Location], "A", DATA[SchoolType], "D", DATA[Program], "Y"),
  ...
)

2. Use FILTER + SUM for More Flexibility

=SUM(FILTER(DATA[Eligibility], 
  (ISNUMBER(MATCH(DATA[Location], {"A","B"}, 0))) *
  (ISNUMBER(MATCH(DATA[SchoolType], {"D","E"}, 0))) *
  (ISNUMBER(MATCH(DATA[Program], {"X","Y"}, 0)))
))

This filters the rows where all three conditions are met and then sums the Eligibility column.

3. Use LET or LAMBDA for Cleaner Logic

You can wrap the logic in a LET or LAMBDA function to make it reusable and readable.