Help with averaging

[GTVT06]

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]

=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]

I'll try that, Thanks alot!!!

=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.