Formula that includes referencing multiple different grid reports and ranges

jcormican

We are looking for a formula that reference how many items they completed throughout the year, by looking at a persons name. Problem is we have to use multiple grid reports and ranges to find the total of items completed for the year. Does any one know of ways to reference multiple grid reports into one equation. Example equation that doesn't work is below

Darren Mullen

@jcormican You can't reference ranges from multiple sheets in the same sumifs() function. HOWEVER, you can sum the result from multiple sumIFS() in one cell.

So you can for example:

SUMIFS({criteria for sheet 1}) + SUMIFS({criteria for sheet 2})+….+ SUMIFS({criteria for sheet N})

You'll just sum the matching values from each sheet.