# 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

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

#### 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
4
Views
172
Replies
1
Views
157
Replies
2
Views
71
Replies
3
Views
98
Replies
2
Views
172

1,126,996
Messages
5,622,078
Members
415,875
Latest member
Tarali

### 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