Im trying to drag and copy a list from a sheet.

on one sheet the numbers are listed horizontal, sort of as a chart, and
the toatals are avg. at the bottom. I want to take the avg.ed numbers
and put them into a vertical chart in another sheet.

How can I format the equation to let me do this?

*right now, it automaticly copies the cells down. I.e. A5, A6, etc.


--
swissforestry
------------------------------------------------------------------------
swissforestry's Profile: http://www.excelforum.com/member.php...o&userid=28719
View this thread: http://www.excelforum.com/showthread...hreadid=509428