Originally Posted by Spencer101

Hi,

Have a look at the attached. Without an example workbook from you it's difficult to pre-empt your layout and what each column is for, so in my example I've used "Yes" in column D to denote whether or not a child will be attending a given event.

I've provided a formula for Excel 2003 and earlier and one for Excel 2007 and later as you didn't stipulate which version you were using.

Hopefully this is of some use to you. Happy to help further if I'm way off the mark with my approach.

S.