Summarizing data tables (what-if analyses)

E

ED2

I'd like to summarize (mean, stdev, min, max, etc.) the data from a on-way or
two-way data table. I WAS able to to this in versions of Excel PRIOR to
2007. However, any formula I type that references a data table is NOT
correctly calculated in Excel 2007. I've tried to address this problem by
changing the recalculation of the spreadsheet to row-wise or column-wise
(which was possible in earlier versions) but this option no longer exists.

Any suggestions?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

TABLE function - Summarizing data tables (what-if analyses) 0
Linking data in MS Word into Excel 5
Pivot Table Summarizing Quirk - Please Help 1
Pivot Table: summarizing two different ways 0
Comparing % Differences From in Pivot Tables 2
Copying just the summarized data 2
Excel 2007 pivot table using analysis services cube as data source 0
Copying a range of data without adjusting formulas 18

Top