i'm looking for a way to sum a cumulative sum based on an order say 1-10
so a formula that looks at order value and adds up in that order
so order =1 - just that number
order =2 - that the number in the cell for order 1 + number for the cell order 2
see attached
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
In cell J2 try:
Cheers,
Please Login or Register to view this content.
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
I used the SumifS function. In cell J2, type =SUMIFS($G$2:$G$11,$H$2:$H$11,"<="&H2)
thanks they both worked - thanks very much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks