return the value if the criteria meet 45 days and the name of the client is not empty.
Answers
-
Hi All,
Can someone help me with the following?
I am trying to use the same formula but referencing a different sheet, I tried several variations, but nothing works.
(#INCORRECT ARGUMENT)
=IFERROR(COUNTIFS({TEST - Implementation 2024 (Range 45)}, "YES", {TEST - Implementation 2024 (Range Customer)}, <>""))
I need to return the value if the criteria meet 45 days and the name of the client is not empty.
Thanks in advance.
-
@Pamella Souza You are forgetting to include the second portion of the IFERROR statement that tells it what to output if the COUTNIFS throws an error.
=IFERROR(COUNTIFS({TEST - Implementation 2024 (Range 45)}, "YES", {TEST - Implementation 2024 (Range Customer)}, <>""), "value if error")
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
@Paul Newcome Thank you for your prompt response.
The IFERROR was my last attempt. What I really want to accomplish here is to count the lines that meet the following criteria (meeting 45 days and a customer name in the customer column).
My original formula is the following:
=SUM(COUNTIF({TEST - Implementation 2024 (Range 45)}, "YES") + COUNTIF({TEST - Implementation 2024 (Range Customer)}, <>" "))
But it is not returning the right value, and I have no idea why.
Thank you!
-
Try it with just the COUNTIFS.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
@Paul Newcome Thank you!
It's working now.
I found the error. Because I had changed it way too many times, the reference range was wrong, and I was missing quotes on one side. Thanks again for the assistance!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!