COUNTIFS with an AND or and OR?


=COUNTIFS([Actionee - SAP]:[Actionee - SAP], "Jess Smith") OR [Actionee - As-Builts]:[Actionee - As-Builts], "Jess Smith")

I am trying to count the number of times Jess Smith appears in columns Actionee - SAP and Actionee - As-Builts. I keep getting unparseable. Looked at many threads and cannot find a countifs multi-column count.

Thanks in advance Paul


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!