Count total


I wish to calculate the total number of hours for a specific region from my list.

so for example I wish to look at column "Region" find all Europe and then count the number of Hours from the "Total Number of Hours" column for all Europe

I tried the below but it only counts the number of times Europe was chosen and not the actual number of hours.

=COUNTIFS(Region:Region, "EUROPE", [Total Number of Hours]:[Total Number of Hours], >0)

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!