Hi there,

My needs may seem unchallenging for the heavy user but I'm a complete novice with excel. I've just been using basic cell formulas up until now.

I have an idea of what I would like to achieve but no idea how to implement it. Can anyone help? I have 3 days...

THE BRIEF: Create an employee absence tracking workbook where 'a checked box' within a cell in any given month acts as '1', so they (the checked boxes) can be counted and 'a sum total' produced within another cell.

This sounds simple enuf to me and I thought a check box system would make life easier for anyone entering data but for a novice like me, it's hard to realise the plan.

I have a great template in place, and can copy & paste additional monthly worksheets, but I need a formula which recognises a check box as '1' and another formula which creates a sum total of 1's!

Is this possible? And if so how?

BH