Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
daverage
I want to use the daverage function to compute the average on several columns
for example according to a certain criteria I may want to copmute the average on columns C, E, and G. Other than taking the average of "nested" daverages, is there a slicker way to do it? Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
daverage
Use a pivot table. Much slicker, easier to change, and doesn't require a single formula.
HTH, Bernie MS Excel MVP "PClancy" wrote in message ... I want to use the daverage function to compute the average on several columns for example according to a certain criteria I may want to copmute the average on columns C, E, and G. Other than taking the average of "nested" daverages, is there a slicker way to do it? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DAVERAGE criteria HELP!!!! | Excel Discussion (Misc queries) | |||
How to tackle Division by zero for DAVERAGE function | Excel Worksheet Functions | |||
Daverage | Excel Discussion (Misc queries) | |||
DAverage Function help needed | Excel Worksheet Functions | |||
daverage problems | Excel Worksheet Functions |