Help with averaging

Hello,
I need help with figuring out how to get a formula to average a column
of numbers excluding blanks and 0's and in the same formula also having
it only calculate/average data that has a certain team name in the row.

This is the current formula I'm using but, the average is not close to
being accurate. I'm thinking it's either calculating some blanks or 0's
or it's calculating data in G5:G505 that belongs to other teams besides
the "Executive Team"

=AVERAGEA(IF(B5:B505="Executive Team",G5:G505))

Let me know if there's another way of doing this.

Thanks

=averagea() will include true/falses in the average. You may want to consider
using =average().

=AVERAGE(IF((B5:B505="Executive Team")*(G5:G505<>0),G5:G505))

still array entered.

GTVT06 wrote:
>
> Hello,
> I need help with figuring out how to get a formula to average a column
> of numbers excluding blanks and 0's and in the same formula also having
> it only calculate/average data that has a certain team name in the row.
>
> This is the current formula I'm using but, the average is not close to
> being accurate. I'm thinking it's either calculating some blanks or 0's
> or it's calculating data in G5:G505 that belongs to other teams besides
> the "Executive Team"
>
> =AVERAGEA(IF(B5:B505="Executive Team",G5:G505))
>
> Let me know if there's another way of doing this.
>
> Thanks

--

Dave Peterson

I'll try that, Thanks alot!!!

Dave Peterson wrote:
> =averagea() will include true/falses in the average. You may want to consider
> using =average().
>
> =AVERAGE(IF((B5:B505="Executive Team")*(G5:G505<>0),G5:G505))
>
> still array entered.
>
> GTVT06 wrote:
> >
> > Hello,
> > I need help with figuring out how to get a formula to average a column
> > of numbers excluding blanks and 0's and in the same formula also having
> > it only calculate/average data that has a certain team name in the row.
> >
> > This is the current formula I'm using but, the average is not close to
> > being accurate. I'm thinking it's either calculating some blanks or 0's
> > or it's calculating data in G5:G505 that belongs to other teams besides
> > the "Executive Team"
> >
> > =AVERAGEA(IF(B5:B505="Executive Team",G5:G505))
> >
> > Let me know if there's another way of doing this.
> >
> > Thanks
>
> --
>
> Dave Peterson