Using a Formula for "sum_range" in a SUMIFS formula

sunshinereel

New Member
Joined
Feb 10, 2022
Messages
7
Office Version
  1. 365
Platform
  1. Windows
  2. Mobile
Is it possible to use a formula for the "sum_range" in a SUMIFS Formula. Here is what I am trying to accomplish

Right now I have to add two columns to my data dump to calculate value of equip and labor amounts and want to just incorporate that into the sumifs formula for my total by month wqorksheet.

In worksheet 1

Column C is a date
Column B is a specific Crop Name
Column G is piece of Equipment used
Column H is an amount of hours an operator worked
Column J is total hrs equipment used
Column N is a location

In worksheet 2
Trying to total Labor hours for January-December based on the crop and the total hours being multiplied by $35
Corn-Location 1 Corn Location 2
January
Labor total in column H with Column C being between 1/1and1/31 multiplied by $35
Equip total equip is a vlookup =(VLOOKUP(G2,'rate sheet'!B:D,3,FALSE)*J2) - rate sheet is another tab that has equipment table with hourly rates for each piece of equipment(hence the Vlookup)

Any suggestions?
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

iggydarsa

Well-known Member
Joined
Jun 28, 2005
Messages
1,659
Office Version
  1. 2019
Platform
  1. Windows
For very little I understand without any data, have you tried pivot tables or =SUMPRODUCT()? Would that help?
 

sunshinereel

New Member
Joined
Feb 10, 2022
Messages
7
Office Version
  1. 365
Platform
  1. Windows
  2. Mobile
For very little I understand without any data, have you tried pivot tables or =SUMPRODUCT()? Would that help?
Thank you for the reply!

believe sum product would work if I didn't have the added variable of basing on dates in another column

Pivot table somewhat works but uneasy to read with the different variables
 

Forum statistics

Threads
1,181,228
Messages
5,928,770
Members
436,628
Latest member
Krakenfan69

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