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
Check out the Formula Handbook template!