How to count from a wider range by a given value in a column?

I want to count how many employees has experience of available projects, my formula is:

=COUNTIFS([Employee A]1:[Employee D]5, ="YES", [Available?]1:[Available?]5, ="YES")

I got an error: #INCORRECT ARGUMENT SET

If I change the first condition to "[Employee A]1:[Employee A]5, ="YES"", it works. Looks like COUNTIFS doesn't support a wider range crosse multiple columns.

Don't want to add up all columns because I have tens of columns in my real sheet, and "Available" column will be modified sometimes so want to make a dynamic formula to calculate.

Any thoughts and any solution??

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!