ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   To find Average (https://www.excelbanter.com/excel-programming/429689-re-find-average.html)

Don Guillett

To find Average
 

There is no such thing as row A. There is row 1 and column A. Why not just
use the AVERAGE function.
What do you want to average and where do you want the number to be placed?
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Murali G" wrote in message
...
Hello-

There is a requirement in my project to find the average of values in a
sheet. Values starts from A1 and goes till G20 (which keeps changing
every
month). For each row we have to find the Average.
For example;
A B C D
-- -- -- --
10 20 10 40
30 40 20 50
50 60 30 60

For Row 'A' we have to find the Average, similarly for 'B','C' and 'D'.

Instead of doing manually is there any code to perform this task by
writing
a macro.

Please let me know if you need any further details.

Regards,
Murali. G




All times are GMT +1. The time now is 10:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com