This is an array formula, are you commiting it by pressing CTRL+SHIFT+ENTER?

--
Regards,
Dave


"cj21" wrote:


=AVERAGE(IF(--(LEFT(TEXT($D$2:$D$5988,"00000000"),2)=TEXT(M3,"00 ")),$H$2:$H$5988))

colomn D is a list of product codes. Some of which begin with a zero so
the column is formated as text.

column M3 is formated as a number.

Column H is formated as a number.

This has been the same for other work i have done and my formula works.
For some reason in this case it does not.

Chris


--
cj21
------------------------------------------------------------------------
cj21's Profile: http://www.excelforum.com/member.php...o&userid=25673
View this thread: http://www.excelforum.com/showthread...hreadid=500178