Hi -
I am in need of a formula that computes the average of dynamic range, I am hoping you can help me. Here's the scenario... I need to get the average of the value from cell A2 down to an unknown location using the cell before the blank cell as the last reference only.
Lets say the result should be in B2.
Thank you
Hudas
So are you saying that there will be blanks (i.e. in A47) and then numbers will continue from that point. Do you want a new average initiated from that point? Uploading an example workbook showing what you want to happen would be very beneifical.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Hi-
Please see sample worksheet. Thank you
Hudas
Try this formula in B2
=AVERAGE(A2:INDEX(A2:A$1000,MATCH(TRUE,INDEX(A2:A$1000="",0),0)))
copy formula to B9
Audere est facere
Thats more like it!! Thank you daddylonglegs...I can't seem to give you star becuase its saying that "You must spread some Reputation around before giving it to daddylonglegs again."
If you never know where the blanks are going to be, try this modification in B2 dragged down
=IF(ISNUMBER(A1),"",AVERAGE(A2:INDEX(A2:A$1000,MATCH(TRUE,INDEX(A2:A$1000="",0),0))))
Thank you both of you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks