# SUMIF for all sheets between 2 specified sheets

#### W Joel

##### New Member
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.

#### Attachments

• Screenshot from 2021-02-07 10-13-50.png
67.3 KB · Views: 8
• Screenshot from 2021-02-07 10-14-16.png
102.4 KB · Views: 8

#### W Joel

##### New Member
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)
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!!!!!!!!!!!!

#### Attachments

• Screenshot from 2021-02-07 12-45-56.png
73.5 KB · Views: 2

### Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

#### Fluff

##### MrExcel MVP, Moderator
You're welcome & thanks for the feedback.
As a matter of interest what app are you using?
Excel Formula:
=SUM(\$Start.O5:\$Stop.O5)
is not a valid Excel formula

Replies
3
Views
50
Replies
4
Views
279
Replies
1
Views
172
Replies
2
Views
111
Replies
3
Views
116

1,129,921
Messages
5,639,011
Members
417,062
Latest member
CM214

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back