I to collate information, but some of the date is #N/A and this will change. I have sorted the Information so #N/A's appear at the bottom -

Cooperation
Curriculum Linked Activities
Familiarisation
Fun
Personal Challenge
Personal Development
Personal State Management
PSE
Self Belief
Skill Acquisition
Support
Training Course
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A


I can collate by &", "& - but i dont need the information of the #N/A - the Ammount of #N/A will vary - so figured using a countif - but its baffling me.

Cheers in advance!