SUMIF for all sheets between 2 specified sheets

[W Joel]

I am new to spreadsheets and have no training. My knowledge is very limited. Screenshots of the spreadsheet I’m creating are attached. I am attempting to total all miles and fuel by state on sheet “Quarterly IFTA Report” for all the sheets between the sheets “Start” and “Stop” Additional sheets between “Start” and “Stop” are added regularly. I have read that I can use =SUMIF. But when I do so I can only get it to work for a single sheet. Can someone please help me with the correct method and formula to accomplish this? I would greatly appreciate the assistance.

 

[W Joel]

I got it!!!!! For C4 on the report sheet =SUM($Start.O4:$Stop.O4) and then the same going down =SUM($Start.O5:$Stop.O5)

This along with your advice

On each sheet between Start & Stop you could put the list of states in (for instance) N4 downwards & in O4 you could put a sumif for the miles on that sheet & in P4 out a sumif for the fuel.
Then on your report sheet you could use in C4

Was the trick. Thank you very much Fluff!!!!!!!!!!!!

 

[Fluff]

You're welcome & thanks for the feedback.
As a matter of interest what app are you using?

=SUM($Start.O5:$Stop.O5)

is not a valid Excel formula