Brain fade in using an OR statement within an averageif function

**Grimace** · 07-30-2012, 01:43 AM

The code i am trying to use, obviously incorrectly, is as follows:

Please Login or Register  to view this content.

If I use it with only a single criteria (eg

Please Login or Register  to view this content.

it works just fine, however i need to average if any of the cells in the column are either a 2,3,4,5 or 6.

I know it should be simple, but im not getting it.
Any advice would be appreciated please

Darren.

**benishiryo** · 07-30-2012, 01:59 AM

hi Darren, noticed you are using Excel 2003 but have AVERAGEIF? if you also have AVERAGEIFS, you can use:
=AVERAGEIFS(E4:E93,B4:B93,">=2",B4:B93,"<=9")

if not:
=SUMPRODUCT((B4:B39>=2)*(B4:B39<=9)*(E4:E39))/SUMPRODUCT((B4:B39>=2)*(B4:B39<=9))

Brain fade in using an OR statement within an averageif function

LinkBack

Thread Tools

Rate This Thread

Display

Brain fade in using an OR statement within an averageif function

Re: Brain fade in using an OR statement within an averageif function

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions