Count values in a column based on values in a different column


I am trying to count all cells that are "green" that are also a "task". "Green" is in a column called "Health" and "task" is in a column called "task type".

=COUNTIF({Turnaround Plan Range 2}="Task" If(AND({Turnaround Plan Range 3}= "Green")


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!