What is wrong with my formula? I want to do a countifs to count by deal stage in a date range.
I am trying to count all of my deals in "Lease Negotiating" that have 2023 open dates.
=COUNTIFS({Master Pipeline Tracker Range 1}, "LEASE NEGOTIATING", >=DATE(2023, 1, 1) {Master Pipeline Tracker Range 3}, <=DATE(2023, 12, 31))
Best Answer
-
Hi @Rudy Biagi
Try this: =COUNTIFS({Master Pipeline Tracker Range 1}, "LEASE NEGOTIATING", {Master Pipeline Tracker Range 3}, >=DATE(2023, 1, 1), {Master Pipeline Tracker Range 3}, <=DATE(2023, 12, 31))
Hope this helps.,
Dave
Answers
-
Hi @Rudy Biagi
Try this: =COUNTIFS({Master Pipeline Tracker Range 1}, "LEASE NEGOTIATING", {Master Pipeline Tracker Range 3}, >=DATE(2023, 1, 1), {Master Pipeline Tracker Range 3}, <=DATE(2023, 12, 31))
Hope this helps.,
Dave
-
This worked. Thanks so much for your help!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!