Hello all ,I have two columns to pull info from in my sheet

Options

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!