Forum Discussion
Need help with a specific formula in Excel that won't produce needed result
I am trying to update an Excel document that was, I believe, retrieved at some point from an online resource. I have two lines tracking certain metrics, and need to add two more. However, when I type...
If the logic is
How many "Action Item" in C13:C66 with "Red" or "High" in F13:F66
when i'd suggest
=SUM(COUNTIFS(C13:C66,"Action Item",F13:F66,{"Red","High"}))
That helped and worked. Thank you!