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

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
Joined
Jun 12, 2014
Messages
56,729
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,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?

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