CountIfs Formula Help

Hi All

I am in need of help with a formula. I am trying to count the number of instances for each of the items in four individual 'Regional' tables and have that amount added up for an 'All Regions' Total.

Using the category 3rd Party Host Connection Problem' in the below attachment as an exxample, I want to add up the number of times it occurs in each of the Regional tables (columns B, G, L and Q) and input that value into cell W32. A simple sum equation gets the desired result, but that presents a problem when I want to filter the data on that table and reorder from smallest to largest value for the purpose of putting into a chart. The data gets reordered but the category names stay in the same order (column U) distorting my data on the chart.

The formula I tried (unsuccessfully) is as follows:

=COUNTIFS($b$31:$b$40, U32, $g$31:$g$40, U32, $l$31:$l$40, U32, $q$31:$q$40, U32)

Any help would be much appreciated! I hope that my description was clear -- please feel free to reach out with any questions.

I have attached the spreadsheet below. The tab I am referring to is 'Excel Templates'.

Hi...Wouldn't it be easier if you just create a pivot table from 'All Regions Incident Type'?

This way, you can have the total of whatever Region (APAC, EMEA etc) you'd like by their categories.

Thanks to all who replied with help. I appreciate the quick replies and found what I was looking for.

@6String - The SUMIF was exactly what I needed. Thanks alot!

Thread is solved.