LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #7   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Average a group of numbers within an date range. sross Excel Worksheet Functions 4 April 22nd 09 11:16 PM
Identify numbers that only occur once in a column. Karen Excel Worksheet Functions 4 September 18th 08 09:01 AM
Average of select range of numbers W Palermo Excel Worksheet Functions 2 June 11th 08 03:30 AM
Average the first nine numbers in a range. Chad Excel Discussion (Misc queries) 2 October 17th 07 06:05 PM
Average first n numbers in a range (there may be less than n numbe Mike A. M. Excel Discussion (Misc queries) 8 January 18th 06 02:55 PM


All times are GMT +1. The time now is 12:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"