sum - lookup count on different tab using 2 variables -


I have data on an Excel sheet where there are about 10 columns but I count the data using only two of them For example:

Column C has district names and Column D says what their title is.

The file contains hundreds of entries and I have to know how many administrators are in 1 district. Only this is the result that will be on a separate tab. I have tried to use Vlookup, but my knowledge only takes me to see a benchmark.

If your "One Excel Sheet" is called Sheet1, District 1 column of that sheet is in C. and in that sheet column there is admin , then on a separate tab:

  = COUNTIFS (sheet 1! C: C , "District 1", Sheet 1! D: D, "Admin")  

Comments