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
Post a Comment