Need help with Countif function please!


I would like to count the rows where:

The "Sales Person" (contact) column is "Kevin Mielke", and also the "Stage" column is one of the following values: "1-Design", "2-Estimating", "3-Delivered", or "4-Contracting".

This is what I came up with but it says "incorrect argument set":

=COUNTIF([Sales Person]:[Sales Person], "Kevin Mielke", Stage:Stage, OR(@cell = "1-Design", @cell = "2-Estimating", @cell = "3-Delivered", @cell = "4-Contracting"))

Thanks in Advance!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!