Formula to Count filtered data (COUNTIFS?)
I am trying to count how many items in Column1 are "High" priority but do not have a value in Column2 of "Closed" or "Withdrawn".
=COUNTIFS(Column1:Column1, "High", Column2:Column2, "Closed") tells me how many are closed - but how do I find out how many are not closed AND not withdrawn?
Any ideas are greatly appreciated.
Help Article Resources
Check out the Formula Handbook template!