tags:

views:

11

answers:

0

I have an excel spreadsheet with a lot of columns. each column contains data which i need to summarize. The desired output is to have the summary in this format...

Column1 name| sum()| average| count
Column2 name| sum()| average| count
etc...

pivot tables wont work for me, because they base their row labels on the values in the columns instead of the column header. i am currently using sum(A:A) average(A:A) etc... to get the statistics but it seems to manual. any ideas?