I have a spreadsheet that lists session numbers in one column A, trainer in column B and date in column C and participant in column D. I need to be able to find out how many different sessions each trainer did, the average number of participants per trainer, the total number of participants per trainer and also by date. When i do a pivot table it gives me total number of participants for trainer but i can't get the number of sessions, have tried subtotals but not getting it
Solved by K. D. in 24 mins