Conditional running total
please help on this issue. i am attaching the file with mannual input. please help how to do this with formula.
row1 is HEADER ROW, and row2 to row13 consists data
IF D13="HOLD", VALUE OF E13 WILL BE SUM OF C13 AND PREVIOUS CELL IN COLUMN C WHOSE VALUE=B13
IF D13="SOLD", VALUE OF E13 WILL BE SUBTRACT (-) OF PREVIOUS CELL IN COLUMN C WHOSE VALUE=B13 AND C13
thanks in advance.
Hi Chandan,
Welcome to the forum.
See the attached file, cell E13 and in case of issues, enter your expected results in E13 and E14 . thanks.
CONDITIONAL RUNNING TOTAL.xlsx
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com
thanks, but what about second criteria? when i sell a scrip how does that reflects in my current balance? is it possible to combine to two formulas with one?
Ok... this is why I asked youafter this, upload your sample workbook.. thanks.in case of issues, enter your expected results in E13 and E14
Regards,
DILIPandey
<click on below 'star' if this helps>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks