Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » CUMULATIVE PROFIT/LOSS

CUMULATIVE PROFIT/LOSS

ResolvedVersion 2007

Thu 16 Feb 2012, 15:15 Delegate Gavin said...

Gavin has attended:
Excel Introduction course
Excel Intermediate course

CUMULATIVE PROFIT/LOSS

I am putting together a financial plan and need the formula to calculate the cumulative profit/loss line which is below the balance (net profit/loss)

b28 is the same as b26
but c28 is b26 + c26
d28 is b26 + c26 + d28
and so on

How do I do this?

Thu 16 Feb 2012, 15:47 Trainer Anthony said...

RE: CUMULATIVE PROFIT/LOSS

Hi Gavin, thanks for your query. Put this into B28 and autofill across:

=SUM($B$26:B26)

Hope this helps,

Anthony

Thu 23 Feb 2012: Automatically marked as resolved.

Excel tip:

Screen Splitters in Excel

Screen splitter icons can be set from the ribbon bar, or dragged from the scroll bars. The icon just above the up arrow on the right scroll bar controls the horizontal splitter; the icon to the right of the right arrow on the bottom scroll bar controls the vertical splitter.

These icons can be double-clicked to split the screen at the top left of the cell currently in use.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

CUMULATIVE PROFIT/LOSS

CUMULATIVE PROFIT/LOSS

RE: CUMULATIVE PROFIT/LOSS

Excel articles

Excel tip:

Screen Splitters in Excel