Average from Vlookup returns

A bug!

Would explain it. I even loaded it onto another machine with 2003.

Does it do the same in other versions of excel anyone?

I'll have a play with it as you suggested. otherwise its back to pencil and paper

Thanks

Originally Posted by arthurbr

Edmdas, no bug I can see, BUT your values in U3 and U4 are text, not numbers
Type the values manually and you will see the formula working as GuruwannaB did)

BTW this formula =AVERAGE(IF(E3:P3<>0;E3:P3)) ( enterd as an array formula) also works

I checked the formats...but I think I did so after I made the changes to U3 and U4...that would indeed explain it! That's why I'm still a "WannaB"!

Guru, you did fine, np.
You were misleaded by the fact that the cells had been center-aligned
You then can't see imediately what is text ( left-aligned) and numbers ( right-aligned)
( on the other hand 2003's error catcher found it for me )

($swearwords!)

It was that simple!?

I spent an hour playing with cell formats even got a network systems guy to have a play with it. I must have changed the table a couple of times, but it makes sense now, only the rows with A*'s and A's were affected

Thank you, I had been doing it manually due to deadline approaching, but you've saved the sweat.

A case of wood for trees,

Thanks Arthurbr

Thanks also to GuruWannaB, better a wanna be than a never be hey!

Edmdas, thx for indicating your thread solved !