I tried to do this latter approach for averages but it didn't work.
My product codes are in column D, their corresponding tariffs are in
column H and my list of 2-digit products ( that correspond to the
8-digit products e.g. 02134567 becomes 02) are in cloumn M.
I put in the following formula:
=AVERAGE(IF(--(LEFT(TEXT($D$2:$D$6088,"00000000"),2)
=TEXT(M2,"00")),$H$3:$H$6088))
This returns an average for product 01 as 24.80, when it should be 23,
what am i doing wrong. Also when i fill down the formula there are just
zeros in every column.
Chris
--
cj21
------------------------------------------------------------------------
cj21's Profile:
http://www.excelforum.com/member.php...o&userid=25673
View this thread:
http://www.excelforum.com/showthread...hreadid=482177