Summarize same item across multiple worksheets – even if they are in different locations…

Another Judge Judy entry – “real cases real people” although the numbers are fake – sorry to disappoint you there…

In this one I show you how to combine using the SUMIFS function with a slightly trickier function called INDIRECT  to create a summary sheet that automatically adds up multiple entries.

The beauty of this approach is that it adds up items in multiple sheets and it allows for new items appearing during the year. Here is the blank version of the file. 

Here is the completed file

Watch the video here