Formula that includes referencing multiple different grid reports and ranges

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!