Thread: Need average of numbers that occur within range
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default Need average of numbers that occur within range
On Wed, 9 Apr 2008 11:33:08 -0700 (PDT), Techhead
wrote:

Thank you, this worked out well. I used this syntax. I replaced the
range with the entire row series. Thanks for your help!

=AVERAGEIFS(G:G,G:G,"=1",G:G,"<=10")

Glad to help. Thanks for the feedback.
--ron
Reply With QuoteReply With Quote