Hello all ,I have two columns to pull info from in my sheet
One column Is State and one column is KEO Estimation Range, one contains In Progress and the other initials of the estimator . My goal is to determine how many rows are in progress and how many belong to the estimator in question ? simply put if I have 20 projects in progress and 2 belong to the initials DR ,that is the end result im trying to perform with the formula / the result I'm getting is unparsable / appreciate any help I can get, thank you
Tony P
Answers
-
Sorry I failed to leave the formula
=COUNTIF({State}, ="In Progress"),AND({KEO Estimation Range 1},= "DR"))
-
Instead of COUNTIF, singular, try COUNTIFS, plural!
=COUNTIFS({State}, "In Progress", {KEO Estimation Range 1}, "DR")
See: COUNTIFS Function
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Hello Genevieve / your formula worked like a charm, thank you TP
-
Glad I could help! 🙂
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 396 Global Discussions
- 213 Industry Talk
- 448 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 133 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!