Looking to create function that counts rows only when 2 conditions are met from different rows
I have two rows in question, one containing a list of states, the other containing a list of "types". I am looking to create a function that only counts rows that satisfy 2 specific criteria. For example, only count rows that contain State = Colorado AND type = payment.
To make things more complicated I am referencing the columns from another sheet.
Any help is greatly appreciated.
Answers
-
James,
You can use the COUNTIFS function!
For example: =COUNTIFS(State:State,="Colorado",Type:Type.="payment")
You would use the "Reference Another Sheet" function but make sure you only select the State column in the other sheet for the first reference. And only the Type column for the second reference.
Hope this works out for you!
Best,
Lidiya Shutaya
lidiya@ddbconsultants.ca
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.5K Get Help
- 367 Global Discussions
- 202 Industry Talk
- 432 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 447 Show & Tell
- 29 Member Spotlight
- 1 SmartStories
- 285 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!