average the sum of every seventh number from 3 to a final value using for..Next loop

**1Melina** · 02-11-2016, 10:41 PM

I wrote this code to find the average sum of every seventh number from 3 to whatever the user enters in the box -
The code I wrote doesn't give the correct average for example if user enter 20, the output should be average which for 20 is 3 because (3+10+17) / 3

Please Login or Register  to view this content.

Can someone check this for me please?

**stnkynts** · 02-11-2016, 11:55 PM

Since in the past you have indicated that this is for a school project I will respond with hints rather than full solutions.

This serves no purpose as it is not used in any other process

Please Login or Register  to view this content.

This is ok in VB but I think it will error in VBA. Look up For next loop in VBA.

Please Login or Register  to view this content.

This is wrong. If sum is your variable you will need to preserve the existing value of the variable when you add the variable count to it

Please Login or Register  to view this content.

Side note: It is usually not a good idea to use built in function names for variables and instead tweak them using the variable type. (i.e. iSum or intSum instead of just sum)

**1Melina** · 02-14-2016, 02:37 PM

I don't get it - I never thought I would be this dumb -
Can you just show it to me. the week past and I didn't get the point on it but I need to learn it.
Would do me a favor and correct the mistake that I have in that.

average the sum of every seventh number from 3 to a final value using for..Next loop

LinkBack

Thread Tools

Rate This Thread

Display

average the sum of every seventh number from 3 to a final value using for..Next loop

Re: average the sum of every seventh number from 3 to a final value using for..Next loop

Re: average the sum of every seventh number from 3 to a final value using for..Next loop

Thread Information

Users Browsing this Thread

Similar Threads

do-while loop to average the sum of every seventh number

[SOLVED] Formula for copying the sixth & seventh digit from a number

how to divide the FINAL RATING with weighted average?

Average if last 3 entries skiping the final entry and excluding blanks

[SOLVED] VBA loop to copy a worksheet a number of times, assign name each time based on loop number

Cells containing 8888 figure, assign each cell an average of final value

[SOLVED] Final Value, For / Next Loop

Bookmarks

Bookmarks

Posting Permissions