COUNTIF Excluding one Status

Hi, Please consider this below table as a scenario where while that I am counting the HR Type against Solution Type if the COUNTIFS formulae, I simply want to exclude "Complete" ones

Below if the formulae that works without the project Status condition. How do I exclude for Complete

=COUNTIF({HR Category},"B",{Solution Type},"3")


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!