Thread: Calculate Average on specific items
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove[_2_] Harlan Grove[_2_] is offline
external usenet poster
  
Posts: 1,231
Default Calculate Average on specific items
"Sandy Mann" wrote...
Try:

=SUM((A2:A5="Mon")*(B2:B5))/COUNTIF(A2:A5,"Mon")
....

Or just

=SUMIF(A2:A5,"Mon",B2:B5)/COUNTIF(A2:A5,"Mon")

without array entry.


Reply With QuoteReply With Quote