Using a Formula for "sum_range" in a SUMIFS formula

[sunshinereel]

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?

 

[iggydarsa]

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

 

[sunshinereel]

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