Hello,

Please can someone help me with a formula for the following:

Column E is labelled “Priority” with drop down options of “High”, “Medium” or “Low” from a lookup table.

Column I is labelled “Status” with drop down options of “Complete”, “In Progress” or “Not Started” from a look up table.

I want to count in cell I2, how many priorities in column E are “high” AND column I has the status “In Progress” OR “Not Started” [i.e. a status that is not “Complete”].

I have created a COUNTIFS formula but cannot seem to apply a second criteria that excludes from the count any with the status “Complete”: =(COUNTIFS($E7:E13,”High”))

I can then adjust the same formula for “Medium” and “Low” priorities for cells I3 and I4 respectively.

​Hello, Please can someone help me with a formula for the following: Column E is labelled “Priority” with drop down options of “High”, “Medium” or “Low” from a lookup table.Column I is labelled “Status” with drop down options of “Complete”, “In Progress” or “Not Started” from a look up table. I want to count in cell I2, how many priorities in column E are “high” AND column I has the status “In Progress” OR “Not Started” [i.e. a status that is not “Complete”]. I have created a COUNTIFS formula but cannot seem to apply a second criteria that excludes from the count any with the status “Complete”: =(COUNTIFS($E7:E13,”High”)) I can then adjust the same formula for “Medium” and “Low” priorities for cells I3 and I4 respectively.    Read More

​