Assuming this isn't a homework question, you can incorporate thos
functions in a UDF whivh could be used anywhere on the sheet, i'm afraid
"January 5" doesn't give us much to go on, as the Mean is 5, Min is 5,
Max is 5...etc

drose;213834 Wrote:
I would like to know if there is a way or function that would allow me
to
look at a table and take the mean, min, max and range of supply for
January.

month supply
January 5
Feburary 4
January 3


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=58695