Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

Averaging data on inserted rows in Excel

Report
-
Posts
2656
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 17, 2020
 -
Hello,

Please after successfully inserting specific number of rows in excel, is there any code that can help you average the data on the inserted rows?
See more

2 replies

Answer 1 / 2
Posts
2656
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 17, 2020
 439
Hi Kurug,

With the given info it is impossible to help you. Could you provide more details?

1. Do you manually insert those rows?
2. Which column(s) of the inserted rows would you like to get the average of?
3. When we have the average, what do you want to do with it? Place it in a cell or show it as a message or ...?

These are just some questions that pops up in my head. If there is more relevant info, do inform us.

Best regards,
Trowa

Report

Please I appreciate your effort to help me and may God richly bless you.

What I actually want to do is that, I have a data which covers a number of countries and variables for the time period 1996 to 2016.

So I want to find the averages for each variable for every three (3) years. This will help me to use the average values for some analysis.

Thank you.

Hope to get your reply soon.
Report

You didnt answer a single question the man asked you. Great job. Dont you know how to manually calculate average? It is sum of all items, divided by the number of items.
Report
Posts
2656
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 17, 2020
 439
Well, as CantFIXstupid kindly pointed out to you, you didn't provide any relevant info to help you. Not sure what you expect from me?
Report

Sorry TrowaD, I thought that will rather make it simple for you to understand me better.

Now in response to your questions,
1) I did not manually inserted the rows. I used a code.
2) I want to get the average for every fifth column of the inserted rows
3) I want to place the averages on a cell

I hope this answers your questions?
Thank you.
Report

any 'ole cell will do, place it into ZZ65789
Answer 2 / 2
Posts
2656
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 17, 2020
 439
Hi Kurug,

No worries.

Some more questions though:

4. Since you use a code to insert rows, I either have to know that the insertion part of the code is at the bottom (meaning, the inserted part is still selected) or I have to know the code (assuming you don't know how to alter your code).

5. There are 16384 columns and I'm pretty sure you don't use all of them. So how many columns do you use or how many averages do you want? No need to make the code do more than is needed.

6. Which range did you have in mind to place the averages?


That should do it.

Best regards,
Trowa

View all 9 comments
Report

Thank you very much.
Report

Hi TrowaD,
Please, how do I calculate normalized standard deviation in a rollowing window for positive and negative values?
Report
Posts
2656
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 17, 2020
 439 > kurugfrancis
Hi Kurug,

Not sure if I fully understand what you mean, but you might be looking for the following function:
=STDEV.P(YourRangeHere)

If not, could you then post some sample data with the result you are after?

Best regards,
Trowa
Report
>
Posts
2656
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 17, 2020
He doesn't understand how to apply it, or what to do with the results. I already answered this to my best in another post....to no avail.
Report
Posts
2656
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 17, 2020
 439 > LamoIdiot5
Pretty cool. I followed your steps and got the same result as the STDEV.P function.

So I got confirmation that the mentioned function is the right one and you got confirmation that your post is followable :).
Reply Ask a question