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 |
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 |
All times are GMT +1. The time now is 11:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com