If statement that will add values

[clinic0320]

I am trying to create a statement that will add all of my vales that equal the letter "S" between page "Beginning "to page "End"???

[JBeaucaire]

I've added a named range to column M. As you add new sheets, add the name of that sheet into that column and the formulas in the table will adjust automatically. This is done via a named range called MySheets that is used in those formulas, and it is defined as all the sheets listed in column M.