# Using a Formula for "sum_range" in a SUMIFS formula

#### sunshinereel

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

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

#### iggydarsa

##### Well-known Member
For very little I understand without any data, have you tried pivot tables or =SUMPRODUCT()? Would that help?

#### sunshinereel

##### New Member
For very little I understand without any data, have you tried pivot tables or =SUMPRODUCT()? Would that help?

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

Replies
4
Views
279
Replies
1
Views
94
Replies
5
Views
149
Replies
2
Views
140
Replies
4
Views
676

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.

### Which adblocker are you using?

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

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