I forgot to specify that I need to look up the minimum, maximum and
average for each name and year, so the "Data" sheet shows 14 results but
since I am looking for the minimum, maximum and average for each name
and year, it is 33. The reason why 2009 is not populated is because if
you filter the "Data" tab, by A1, and date, the column D "year" does not
show 2009. I populated manually the table in the "Amt by Year" tab.

Simon Lloyd;432104 Wrote:
In fact you have 33 values in your table but the criteria you want to
use would only produce 14 results?


--
confused
------------------------------------------------------------------------
confused's Profile: http://www.thecodecage.com/forumz/member.php?userid=572
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=119295