SumIfs Formula

Nicole Martin

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.

kowal

hi @Nicole Martin,

have you tried sth like:

=sumeifs(Job_value:Job_value, accounts:accounts, =1, date:date, >Jan 2024, date:date, <Nov 2024)

hope it helps.