Writing a formula to sum a specific range from a sheet if another range in the same sheet is equal to a cell value in a third summary sheet

[MrN]

I am trying to write a formula in excel. I have a summary sheet that has equipment numbers in one column and sheet reference values in a row. I also have multiple sheets that have names equal to the values in the row mentioned. I want to use the indirect function to sum the range in column G of a specific sheet (based on a sheet reference) if the cell in column E of the same specific sheet matches the equipment number in my summary sheet. I have tried a bunch of different formulas but they all give me a reference error. Here is my latest version of the formula:
=SUMIFS(INDIRECT("'" & $O$2 & "'!G2:G500"), INDIRECT("'" & $O$2 & "'!E2:E500"), B8)
Here are some pictures of my spreadsheet:
Summary:


'13' Sheet:


Any help is appreciated. Thank you

 

[Fluff]

Hi & welcome to MrExcel.
There is nothing wrong with the formula, if you are getting #REF errors, make sure both O2 & the actual sheet name don't have any leading/trailing spaces.

 

[MrN]

Nevermind, I realized the cell O2 in my summary was a date and not just a number so I used the day function to convert and it works now. Thank you

 

[Fluff]

Glad you sorted it & thanks for the feedback.