COUNTIF to count cells with a date less than, and ignore blank cells
Good afternoon.
I am trying to count some data in a Date Closed column.
- I want to count the number of cells showing a date less than 4/30/21. There are some blank cells that I am not sure how to account for.
=COUNTIF({Circle K Summary Date Closed}, @cell <= DATE(2021, 4, 30))
- I am also going to want to sum the amounts in a Final Sale Price column as related to these dates. For instance, sum all sales prices in the smartsheet column for closing less than 4/30/21.
Appreciate the help. I keep playing with it. Might come to me in the middle of the night and I am reading a ton of posts, but just can't get it right.
Thanks.
Answers
-
COUNTIF will not include blank cells so you should be good with the blank cells.
For the sum use the same expression with SUMIF function like,
=SUMIF({Circle K Summary Date Closed}, <= DATE(2021, 4, 30), [Final Sale Price]:[Final Sale Price])
-
The Countif is working. I had a mistake in my summary sheet.
If I want it between dates - such as between 5/1/22 and 4/30/23, what does that formula look like?
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
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!