COUNTIF Function with Dynamic Range

I'm attempting to use the COUNTIF formula in multiple fields of a report in a worksheet named "Cover Page". The data is in a worksheet named "Raw_Data". The issue I'm having is that the columns I'm using for the range criteria in the COUNTIF formula are never consistent. In other words, the columns in the worksheet "Raw_Data" are never in the same order. The header names are the same however. An example is where I'm counting instances 'Closed' in a column named 'Case Status':

=COUNTIF(Raw_Data!Y:Y,"Closed")

The formula works, but when I load the new data, chances are the 'Case Status' column will not be column Y. I considered using named ranges, but I'm not sure what formula to use for the reference (possibly the INDEX and MATCH function). I think this is the direction to go, as the formulas will be easier to manage and the ranges will dynamically change. I'm open to all suggestions.

Here is an example of the workbook I'm using. I apologize, but I had to remove a large amount of confidential data. It's still functional as far as what I'm trying to accomplish in this post. In actuality, though, the formula I would be using is COUNTIFS instead of COUNTIF since I have multiple conditions (case status and country)...I was just trying to keep it simple.

Marcol, that's perfect! It's exactly what I wanted to accomplish. Out of curiosity, why the two named ranges csCol and Case_Status? Couldn't you combine them? It looks like csCol returns the column number.

hello everyone i m new for this forum, so dont know how to make a new post

I have a problem in function countif
actually i want to use countif function which change itself after change in a cell reference
but my problem is that i want to get exact match
for example if cell refrence has value "RAJ" , then it gives many count which has RAJ and I want to know the exact match for RAJ

please help me guys