Hi,

I'm looking for a formula that averages a selection within a dataset.
However, a user of the sheet should be able to determine which
selection is made. For instance, a user has to be able whether to
average the data matching with column A = x, or column A = y. Moreover,
the formula should take into account that within this selection, another
selection can be made, i.e. average of A = x, B = z. Finally, I'm
desperately looking for a graph which follows this selection, i.e. plot
the retrieved data over the years (average over all cells for which A=x,
B=z, and C(year)=2000, or 2000-2002...). I hope someone can help me...

Thanks,

Peter


--
Peter1999
------------------------------------------------------------------------
Peter1999's Profile: http://www.excelforum.com/member.php...o&userid=33997
View this thread: http://www.excelforum.com/showthread...hreadid=537609