Hi all,
I have a problem where i need to create a running total and i am really failing to get a result.
Here is the latest formula that ive made. C11 is a % and unless i actually put a value it returns 0
Can anyone help me with this..
Please Login or Register to view this content.
Thanks
loopiloo
There's no context to your question. A blank cell in an arithmetic formula is treated as zero, and your sum function is redundant.
Entia non sunt multiplicanda sine necessitate
Ive tried like this but no successCan you please tell me how i can get the sum function to work even with a blank cell in C11Please Login or Register to view this content.
Ive tried like this but no successCan you please tell me how i can get the sum function to work even with a blank cell in C11Please Login or Register to view this content.
=SUM(G10,F11)*IF(C10="",1,C10) would do it
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
i put your formula and just changed the cells slightly to make it work =SUM(G10,F11)*IF(C11="",1,C11) and it produces the value of the % entered into C9
what i am trying to achieve is a running total (Not sure how to explain clearly) ie: the last value(G10) plus new value(F11) minus the percentage(C11) equals result. drag this down to repeat on each new row... Hope i am explaining good...
Untested but you could give it a try.
Please Login or Register to view this content.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Thanks but this is just showing error.. not sure what to modify.???
I think you get better help if you add an excel file, without confidentional information.
also add the desired (expected) result.
Hi loopiloo,
The formula you need is in column G (G11 to G21) - see attached spreadsheet - just copy it down to include more rows.
Regards
peterrc
Here is a picture... i dont know how to upload a doc hope it helps to make the problem clear
running total problem.jpg
Here is a picture... i dont know how to upload a doc hope it helps to make the problem clear
Attachment 241709
Here is a picture... i dont know how to upload a doc hope it helps to make the problem clear
Attachment 241709
Hi Loopiloo,
Please see attached.
Regards
peterrc
See the formula in the attached file.
J21 =SUM($F$21:$F21)
and drag down.
Is this what you're up to?
Hi Loopiloo.
The formula I have offered is based on:-
1. Mutiplying the total by the percentage - not minus the percentage
2. The figures in the Pool column shown in the "picture" you attached are what you are trying to achieve.
Please see attached.
Regards
peterrc
Hi Loopiloo,
Please see attached (it doesn't look as if my last post "uploaded" properly).
Regards
peterrc
Hi guys and thanks for your help so far... i have attached a file with some explanations.. i am really not managing to get the required result.. please help
running total problem.xlsx
I would put, in G8 copied down
=SUM(H7,F8)-C8*(SUM(H7,F8))
In line 12, you purchased 15000 so wouldn't the new total for that row be 20250 and not 6750?
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
Thats solved it ChemistB... thank a lot...! you were right.. i forgot to add the 15,000 to make it 20250
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks