COUNTIFS Statement Help
Emily Swartz
✭✭✭
I am trying to COUNTIFS but have been unsuccessful so far. I need to count the status of a project if it is a certain product. I keep getting #INCORRECT
=COUNTIFS(Status3:Status51, "Green", Product:Product, "Rapid Test")
Thanks.
Tags:
Comments
-
Hi eswartz,
You're seeing the error because your 2 ranges are different sizes. The first range is dealing with 49 rows, while the second is looking at the whole column.
If you change the formula to the following, you'll be good:
=COUNTIFS(Status:Status, "Green", Product:Product, "Rapid Test")
-
To add to the above
Or you can keep the same column ranges for both the columns
=COUNTIFS(Status3:Status51, "Green", Product3:Product51, "Rapid Test")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- 10.9K Get Help
- 65 Global Discussions
- 69 Industry Talk
- 385 Announcements
- 3.6K Ideas & Feature Requests
- 56 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 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!