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)
Help Article Resources
Check out the Formula Handbook template!