Average if the number is below 95%

**jenncess** · 04-29-2013, 02:02 PM

I also need it to exclude zeros, when I look for a formula I keep running across averageif but that looks at 2 separate columns, I just need it to look at one column.

Thanks again...

**Jonmo1** · 04-29-2013, 02:04 PM

Averageif doesn't "HAVE" to look at 2 columns.. You can specify any column you want.

But since you're specifying 2 criteria, Less than 95% and NOT 0..then you need AverageIfS

Try
=AVERAGEIFS(A1:A100,A1:A100,"<95%",A1:A100,"<>0")

**etaf** · 04-29-2013, 02:07 PM

removed post - better answer provided

**jenncess** · 04-29-2013, 02:10 PM

BAM!! You are awesome... thanks..

**Tony Valko** · 04-29-2013, 02:11 PM

Try something like this...

=AVERAGEIFS(A2:A10,A2:A10,">0",A2:A10,"<0.95")

Average if the number is below 95%

LinkBack

Thread Tools

Rate This Thread

Display

Average if the number is below 95%

Re: Average if the number is below 95%

Re: Average if the number is below 95%

Re: Average if the number is below 95%

Re: Average if the number is below 95%

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions