Calculate totals of two categories within a date range?

I want to display a stacked bar graph in a widget that shows the total amount by month in the "Awarded or Expected Award Date" column broken out into "Funded" and "Submitted". I've included a screenshot of what I'm attempting to do.

I found this formula in another discussion thread and tried to adapt but I know it's missing some pieces. Any help is appreciated!

=COUNTIFS({Award Date}, >=Date(2020, 01,01), {Award Date}, <= Date(2020,01,30))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!