Average formula excluding a specific word in column

[C_Hansen]

Hi all,

I am looking for help with a formula which allows me to ignore a specific word in the column.
for example; column contains different departments & Retail. I want to do an average of all excluding Retail.

I have used this formula to do average of only Retail. Now I need to do average of everything else combined.

=AVERAGEIF('Filled Roles'!,E2:E106,"RETAIL",'Filled Roles'!K2:K106)

thanks,

C_Hansen

 

[C_Hansen]

To add there are too many other departments, for me to add them separately ...

 

[gaz_chops]

Welcome to Mr Excel,

Try

=AVERAGEIF('Filled Roles'!,E2:E106,"<>RETAIL",'Filled Roles'!K2:K106)

 

[C_Hansen]

thanks Gaz, that doesn't seem to work unfortunately.

 

[gaz_chops]

It works fine for me! How is it not working?

 

[Fluff]

There looks to be an extra comma in there, try
=AVERAGEIF('Filled Roles'!E2:E106,"<>RETAIL",'Filled Roles'!K2:K106)

 

[gaz_chops]

There looks to be an extra comma in there, try
=AVERAGEIF('Filled Roles'!E2:E106,"<>RETAIL",'Filled Roles'!K2:K106)

Well spotted I copied the OP's formula & didn't check it!