Countifs with multiple criteria in one column


Trying to use countifs with the first column having multiple criteria. I need the count in {B3, BRIDGE, C2B Subfleet}, =319 or "3HF". I am counting for a metrics widget so I do not want to separate the count.

=COUNTIFS({B3, BRIDGE, C2B Subfleet}, =319, {B3, BRIDGE, C2B In}, >=TODAY(), {B3, BRIDGE, C2B In}, <=TODAY(7))

Thank you in advance, Garrett

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!