Richard wrote:
.. Now I want to transpose the category headings, which are in a row to
a column setting. No problem. But when I go to do the monthly average I
just get the #REF! message in the whole column.

Could you go to the top* cell in that column, copy directly from the formula
bar & paste the formula thats returning this error message in reply ?
*I'll presume you're copying this cell down the whole column

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---