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
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!