Collect (Sumif xxx)

Joerg Schmidt

Hi, I have following challenge ;-)

my sheet:

reason costs

reason1 x €

reason2 y €

reason3 z €

how can I calculate in a formula how much Costs are depending on various reasons?

Chris Mondeau

=sumif(Reason:Reason, @cell = "Reason 1",Amount:Amount), then just change Reason 1 to Reason 2 etc.. for each condition.

Chris Mondeau

=sumif(Reason:Reason, @cell = "Reason 1",Amount:Amount), then just change Reason 1 to Reason 2 etc.. for each condition.

Colleen Marshall

How would you use this formula, to add another sumif statement?

My sheet says something like:

Labor Rate/hr Subtotals

Fabrication $45 $45

Fabrication $45 $45

Design Work $45 $45

Fabrication $65 $65 <- Here there was a rate change

IF the Labor is Fabrication, and IF the rate was at $45/hr, I want to add up those subtotals.

Genevieve P.

Hi @Colleen Marshall

It looks like you created a post about this and were answered here: https://community.smartsheet.com/discussion/70135/nested-sumif-formulas-across-multiple-sheets#latest

Let us know if you still have questions!

Cheers,

Genevieve