Hi all, I'm trying to count the number of individuals belong to a user defined group. Specifically I want to show the number of colleagues who have completed more than 75 hours of training, based on time sheet data in the attached workbook.

I attempted to group together individuals based on whether they had completed more than 75 hours using the following logic:

if SUM(IF ([Type (group)])='Training' then [Recorded Hours] ELSE 0 end)<75 then "less than 75 hours" ELSE "more than 75 hours" END

However, this doesn't produce the result I need as can be seen on the "Count by Training Category" worksheet, which only displays the "more than 75 hours category" and the count of individuals in this category is incorrect (it should only be 2 i.e Person 4 and 5).

All help gratefully received!

Thanks and regards,

Sandeep