Hi,

I'm trying to colleate several spreadsheets by highlighting key information. We run several courses and it would be nice to have 1 central sheet where we can check number of delegates per course.

At the moment i'm using countif formulas on each register, to count the names of delegates, and also count schools.
We have 1 course that has 3 seperate parts (A,B and C)
Is there a formula to count say- if Cell D4 contains A, then count C4 (name of delegate) if D4 does not contain A, do not count.