Sum of total pend per Quarter

Max Ahmed

What's wrong with Formula?

Genevieve P.

Hi @Max Ahmed

Ah my apologies! Since we're using SUMIFS in this instance, you'll want to have the column to SUM be the first range, not the last.

Try:

=SUMIFS({Pipeline-Remodel Completion Dates cost}, {Pipeline-Remodel Completion Dates Start}, >=Date(2021, 4, 1), {Pipeline-Remodel Completion Dates Start}, <=Date(2021, 7, 31))

Genevieve P.

Hi @Max Ahmed

If you're looking for multiple criteria in a SUMIF, you'll want to use SUMIFS (plural) instead. With a SUMIFS, the column to SUM is actually the last range that you list. See: SUMIFS Function

Try:

=SUMIFS({Remodel Pipeline Big Picture Summary Range 1}, >=DATE(2021, 4, 1), {Remodel Pipeline Big Picture Summary Range 1}, <=DATE(2021, 7, 31), {Pipeline-Remodel Range 3})

Note that both {Remodel Pipeline Big Picture Summary Range 1} and {Pipeline-Remodel Range 3} will need to be looking at the same sheet.

Let me know if this has resolved your issue!

Cheers,

Genevieve

Max Ahmed

I think the Problem is that they are separate sheets. I have tried sumifs with the formula before. Let me amend it to the same sheet and see if i get a result

Max Ahmed

Still Getting invalid Operation

Genevieve P.

Hi @Max Ahmed

Ah my apologies! Since we're using SUMIFS in this instance, you'll want to have the column to SUM be the first range, not the last.

Try:

=SUMIFS({Pipeline-Remodel Completion Dates cost}, {Pipeline-Remodel Completion Dates Start}, >=Date(2021, 4, 1), {Pipeline-Remodel Completion Dates Start}, <=Date(2021, 7, 31))