Counting instances that are not near each other

  • Thread starter Thread starter raehippychick
  • Start date Start date
R

raehippychick

Each week I have to find the total number of employees by grade - fo
example there could be five employees in grade Z100 this week and 7 th
next week.

However the way the spreadsheet is designed is that the grades are no
all together - they may be in different rows and in different column
as columns A,B&C are replicated across a few times

Sheet is basically like this:

Column A has Employee Grade e.g. Z100
Column B has COUNTA of the grades [=COUNTA(C3:C12)]
Column C has employee names

Grades may be in row 3 but will have a number of rows next to and belo
with names in column C, but Directly next to the Grade cell there is
COUNTA - I would like to total all COUNTA cells but conditionally so
can have a total for each grade

A B C
[Grade, Count, Name]
A1=Z100 B1=2 C1=Fred
C2=Harry
A3=Z200 B3=3 C3=Mary
C4=Andy
C5=Ann
A6=Z100 B6=1 C6=Bert

I cannot alter this spreadsheet as it is not mine but I could reques
the totals I need to be added at the bottom

Please could anyone help me with a formula that will look at the whol
sheet area and find and total of each instance e.g. find all people wh
are Z100 grade?

So that in Column B at the bottom of the rest of the data I could hav
a list of totals by grade?

Many thank
 
Back
Top