T
tralbert
I'm working with a spreadsheet that in part looks at Trainee
retention/turnover. When a trainee leaves, I count it in the total for the
area using a COUNTIF function. I also need to acquire a total for each of the
two trainers in the area (note the trainees are not sorted by trainer so I
don't think using SUBTOTAL would be an option here). An example would be as
follows:
Trainee Trainer Turnover/Retention
Sample 1 Trainer A Y
Sample 2 Trainer B N
Sample 3 Trainer B Y
Sample 4 Trainer A N
Total Trainer A
Total Trainer B
Area Total
I tried using the following formula to get the results, but Excel isn't
liking it. I'm thinking I don't have the parentheses correct.
=SUMIF(C5:C24, "Trainer A",{COUNTIF(I5:I24, "N")})
Anyone have any ideas/opinions on this?
Thanks!
retention/turnover. When a trainee leaves, I count it in the total for the
area using a COUNTIF function. I also need to acquire a total for each of the
two trainers in the area (note the trainees are not sorted by trainer so I
don't think using SUBTOTAL would be an option here). An example would be as
follows:
Trainee Trainer Turnover/Retention
Sample 1 Trainer A Y
Sample 2 Trainer B N
Sample 3 Trainer B Y
Sample 4 Trainer A N
Total Trainer A
Total Trainer B
Area Total
I tried using the following formula to get the results, but Excel isn't
liking it. I'm thinking I don't have the parentheses correct.
=SUMIF(C5:C24, "Trainer A",{COUNTIF(I5:I24, "N")})
Anyone have any ideas/opinions on this?
Thanks!