COUNTIFS function with multiple criteria

RMaresca
RMaresca
edited 06/30/22 in Formulas and Functions

Hello!

I've been having trouble with getting this formula correct.  Here are the details.

 

I want to count row A when "service expansion" is present only if row B has "qualifying" or "proposal"  or "Negotiation" listed.

I've tried several variations but can't seem to get this one!

 

 

Tags:

Best Answer

«134

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!