Thread: How to average the last 10 numbers in a row?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John P[_2_] John P[_2_] is offline
external usenet poster
  
Posts: 29
Default How to average the last 10 numbers in a row?
How can I write a formula to calculate the average for the last 10
positive/negative numbers in a row eg. B4:BX4 if:


1. Row B4:BX4 has both positive and negative numbers without zeros

2. Row B4:BX4 has both positive and negative numbers and may contain zeros

I have tried my best for the last 2 weeks and hope somebody can enlighten me
here. Thanks.


Reply With QuoteReply With Quote