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
-
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.
The Real Smartsheet Enthusiast
Is there anything else we can help you with? - book your time!
MASA Consult - Your Aligned Smartsheet Partner
Find us on LinkedIn!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!