SUMIF for all sheets between 2 specified sheets

W Joel

New Member
Joined
Feb 7, 2021
Messages
7
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
    Screenshot from 2021-02-07 10-13-50.png
    67.3 KB · Views: 8
  • Screenshot from 2021-02-07 10-14-16.png
    Screenshot from 2021-02-07 10-14-16.png
    102.4 KB · Views: 8

W Joel

New Member
Joined
Feb 7, 2021
Messages
7
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!!!!!!!!!!!!
 

Attachments

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

Some videos you may like

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
Joined
Jun 12, 2014
Messages
55,253
Office Version
  1. 365
Platform
  1. Windows
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
 

Watch MrExcel Video

Forum statistics

Threads
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?

Disable AdBlock

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
Top