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.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 464 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!