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


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!