Count total

Paul Molloy

Hi

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)

Andrée Starå

Hi @Paul Molloy

I hope you're well and safe!

You'd use a SUMIF instead.

Try something like this.

=SUMIF(Region:Region, "EUROPE", [Total Number of Hours]:[Total Number of Hours])

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Paul Molloy

I hope you're well and safe!

You'd use a SUMIF instead.

Try something like this.

=SUMIF(Region:Region, "EUROPE", [Total Number of Hours]:[Total Number of Hours])

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Paul Molloy

Wow that works perfectly.

thanks you Andree

Andrée Starå

@Paul Molloy

Excellent!

You're more than welcome!