Hi Experts,
I need to use a simple sum formula but the range is not fixed all the time.
I need to decide the range depending on other cells.
Please have a look at the attached file and suggest which formula I should use to construct range for Sum Formula dynamically. (I think offset formula may help here)
P.S. : I'm not allowed to use Macro for this.
Thank in Advance!
Last edited by Tejas.T; 12-29-2012 at 02:54 PM.
In C2 cell
Formula:
Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Hi Tejas,
Use below formula :-
=SUM(OFFSET($B$6,$A$2,0,$B$2-$A$2+1,1))
Regards,
DILIPandey
<click on below * if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
@dilipandey:
Thank you very much for the smart formula
@Sixthsense:
I think you misunderstood my question. Anyways, thank for the try.
you welcome Tejas..
suggest you to mark this thread as [SOLVED]..
Regards,
DILIPandey
<click on below * if this helps>
Hi,
I have done that. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks