| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum per row and Average per column from a second sheet.
OK. I have 4 colums in my table on sheet 2.
In the cell on sheet 1 I want to look at Sheet 2, Column 1 and (if it contains anything) add columns 2, 3, and 4 together for that row. Then Average these sums in one total. 1 2 3 4 ------------------------ A|Client1|10|20|30 B|Client2|10|20|30 C| |10|20|30 D|Client4|10|20|30 We should get the following. A| 10+20+30=60 B| 10+20+30=60 C| 0 (Because column 1 is empty) D| 10+20+30=60 ------------------------- 60 +60 +60 ----- 180 / 3=60 Average score or each row, 60. Does that make sense, and if so, how can I make it happen? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculate average in a column based on criteria in another column | Excel Discussion (Misc queries) | |||
| Sum/average numbers in column A dependant on value in column B | Excel Worksheet Functions | |||
| in the average sum etc at bottom of sheet add a custom tab | Excel Worksheet Functions | |||
| Column chart with additional "average" column | Charts and Charting in Excel | |||
| I need to find the Average from Column A - but Reference Column B | Excel Worksheet Functions | |||
Threaded Mode
