SumIfs Formula

Good day.

I would like to add in my summary a formula, it is the sum of the revenue, not made, for each Month.

So it it the JOB_VALUE column - to indicate the value of the job

ACCOUNTS columns - to indicate if it was invoiced (Drop down column - 1. Invoiced 2. Not Invoiced

DATE of job column - this contains a dates from 2022 - 2024, I would like to have the dates for

Jan 2024-Nov 2024

I am currently struggling with this formula on my sheet.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!