Sheet Summary Formula

I hope you're well and safe!

You'd need to use SUMIF.

Try something like this.

=SUMIF([Date Awarded]:[Date Awarded], IFERROR(MONTH(@cell), 0) = 9,[Amount Awarded]:[Amount Awarded])

Did that work/help?

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

@Matt Gleaves

Excellent!

Happy to help!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Genevieve P.

As soon as you have more than one criteria, you'll want to use a SUMIFS (plural). The structure is the opposite, where you list the column/range you want to SUM first, then write the rest of the formula.

See: SUMIFS Function

Try something like:

=SUMIFS([Contract Amount]:[Contract Amount], [Date Awarded]:[Date Awarded], IFERROR(YEAR(@cell), 0) = 2022, [Date Awarded]:[Date Awarded], IFERROR(MONTH(@cell), 0) = 1)

Cheers,

Genevieve

All comments

I hope you're well and safe!

You'd need to use SUMIF.

Try something like this.

=SUMIF([Date Awarded]:[Date Awarded], IFERROR(MONTH(@cell), 0) = 9,[Amount Awarded]:[Amount Awarded])

Did that work/help?

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

Hi @Andrée Starå! Thank you! I knew it was super simple and I was simply overthinking it!

Thank you!

@Matt Gleaves

Excellent!

Happy to help!

@Andrée Starå I could use your help again. I need to separate the years for the amount awarded in a summary:

Any thoughts? Here is my formula:

=SUMIF([Date Awarded]:[Date Awarded], IFERROR(MONTH(@cell), 0) = 1, [Contract Amount]:[Contract Amount])

Here is my updated formula. I feel like I am close but obviously something is not working correctly.

=SUMIF([Date Awarded]:[Date Awarded], IFERROR(YEAR(@cell), 0) = 2022, [Date Awarded]:[Date Awarded], IFERROR(MONTH(@cell), 0) = 1, [Contract Amount]:[Contract Amount])

Genevieve P.

See: SUMIFS Function

Try something like:

=SUMIFS([Contract Amount]:[Contract Amount], [Date Awarded]:[Date Awarded], IFERROR(YEAR(@cell), 0) = 2022, [Date Awarded]:[Date Awarded], IFERROR(MONTH(@cell), 0) = 1)

Cheers,

Genevieve