This has probably been answered several times but I can't find an answer for the life of me. Apologies for that.
I have a formula in a cell:
=AVERAGE(B3:B14)
When I drag it down to autofill the formula reads:
=AVERAGE(B4:B15)
However I want the formula to jump by 12 rather than by 1 to say:
=AVERAGE(B15:B26)
Does that make sense? I have a long list of monthly data over many years and am calculating the annual average.
Hi, welcome to the forum
This can be done, but I have a feeling you need to take a look at the AVERAGEIF() function instead?
If you still have a problem, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi, welcome to the forum
This can be done, but I have a feeling you need to take a look at the AVERAGEIF() function instead?
If you still have a problem, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks