counting number of times a word appears in column A dependent on Column B
Best Answer
-
=COUNTIFS([Column A]:[Column A], ="Paid", [Column B]:[Column B], ="Invoiced")
The COUNTIF works like an "AND" statement so "Paid" AND "Invoiced"
So if it Has "Paid" and "Credited" it will not be counted..
Brent C. Wilson, P.Eng, PMP, Prince2
Facilityy Professional Services Inc.
http://www.facilityy.com
Answers
-
=COUNTIFS([Column A]:[Column A], ="Paid", [Column B]:[Column B], ="Invoiced")
The COUNTIF works like an "AND" statement so "Paid" AND "Invoiced"
So if it Has "Paid" and "Credited" it will not be counted..
Brent C. Wilson, P.Eng, PMP, Prince2
Facilityy Professional Services Inc.
http://www.facilityy.com
-
Thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 200 Industry Talk
- 430 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 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!