Thread: Calculating Average of Certain Cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tags Tags is offline
external usenet poster
  
Posts: 3
Default Calculating Average of Certain Cells
I want to find the average time of cells that only have X in them. For
example:
Name Comercial TIME
Belair X 0:30
York 0:15
Dulaney X 0:45
Providence 0:15
Joppa X 0:55

What formula do I use?
Reply With QuoteReply With Quote