have you tried using the count or countif functions?

"Ani63" wrote:

my worksheet has names and dates when reviews and training is due. I need to
add how many people are up to date and want to add columns totals but can not
assign a value to the cells containing the due dates. Is there a way to
adding how many I have in each column, not counting the ones that are due
shortly? Many thanks