Thanks for the quick reply.

This doesnt really show what i'm after im afraid.

Basically, sheet1 is a task list that has many columns, many users ect about 30 colums in total.

Sheet 2 shows a summary of this task list which includes each user, number of tasks complete, pending, in progress ect.

I would like to add another column that shows The number of tasks each user has that is overdue an thus need a formula that does what i mentioned in my opening post?

Any ideas?


Thanks