ExcelBanter - Finding an Average based on a Condition

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Finding an Average based on a Condition (https://www.excelbanter.com/excel-programming/300328-finding-average-based-condition.html)

poloxstar[_6_]

Finding an Average based on a Condition

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 coul
help?
Thank

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

Tom Ogilvy

Finding an Average based on a Condition

=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/

All times are GMT +1. The time now is 02:30 PM.