COUNTIFS multiple columns

Hi @Paul Newcome I have another interesting scenario I wonder if I can solve with a formula. I have three columns with numbers 1....5 I want to calculate between those three columns anytime a value is >=1 to count as 1 and not every time the value is true. I know I can count the three columns =COUNTIFS([Summer 2019]:[Spring 2020], however if a value appears in all three columns then I'm receiving duplicate counts for the row. And I want the row to only be counted once and not three times if a value appears. I'm trying to say if a value appears at least one time it should return as 1 count not a 3. Hopefully the screenshot below can assist what I'm trying to do.

Any suggestions ideas?


Senior Program Coordinator

De Anza College

Tags:

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!