=Sumif(A:A,9999,B:B)/countif(A:A,9999)

--
Regards,
Tom Ogilvy

"poloxstar " wrote in message
...
Hi,
I am need of assistance
I am stuck with a formula

ClearCode Resolve Time
9999 60
8888 47
9999 55

I want to know the Average Resolve Time for Clear Code 9999

I am stuck on the formula. Is there an excel Guru around that could
help?
Thanks


---
Message posted from http://www.ExcelForum.com/