Countif / sumif ?

Hi everyone,

I'm looking for a formula which will give the number I obtain when I filter such as :

I want to know how much "Club Readiness" Online we've when "Current System" column is one of the 2 values selected (let's call them "X" and "Y").

I tried with COUNTIFS, and with COUNTFS with IF function nested, but without good results.

Any ideas?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!