Alert icon
We're changing our privacy policy. This stuff matters.  Learn more  Dismiss

HOW TO CALCULATE and ADD RUNNING PERCENTAGE formula IN EXCEL

Loading...

Sign in or sign up now!
33,462
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Oct 23, 2009

The same way u can Subtract
just put (-) sign to subtract.
- SIGN to subtract

+SIGN to add

* MULTIPLY

/ DIVIDE

SOME FORMULAS:

=sum(B4:B16)-sum(B19:B25)
This formula will add up the contents of cells B4 to B16.
It will also add up the contents of cells B19 to B25 as a
separate calculation and then subtract the answer it got
from adding up cells B19 to B25 from the answer it got
from adding up the contents of cells B4 to B16.

=sum(B3:B6)*75%
This formula will add up the contents of cells B3 to B6
and then multiply the resulting sum by 75%.


=sum(B2:B18)-B20
This formula will add up the contents of
cells B2 to B18 and then subtract the value
of B20 from its answer

=(B3*2.5%)+B3
This formula will calculate 2.5% of the value of
cell B3 and then add that calculation to the original
amount in B3.

Category:

Film & Animation

Tags:

License:

Standard YouTube License

Link to this comment:

Share to:

Uploader Comments (tiktam51)

  • It s absolutely not clear what the author is trying to show in this video.

  • @dooric This is calculating running percentage do it ur self in excel as shown here and u will understand or u can make ur tutorial no problem.

  • Can you let me know what the music is?

    And thanks for the % advice it works a treat.

    Cheers

  • The music is from Audio Swap from this

    site and is not showing up

    when i click Statistics & Data

    so it's difficult to tell at present

see all

All Comments (9)

Sign In or Sign Up now to post a comment!
  • this does not work for me, when i drag the plus arrow, it all comes up with the same number, frustrating

  • I want to find out how to calculate PERCENTAGE!!! as your video title said...

  • Thanks so much! I couldn't figure out how to do percentages and was about to destroy my computer. Because of you I was able to complete my homework!

  • Your video is very good

    and helped me in my work

    was what I was looking Thank you

Loading...

0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more