Excel Magic Trick 475: SUMPRODUCT for Bank Deposit Calculation

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
1,874
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Jan 8, 2010

See how to enter number of bills in deposit and quickly calculate the total for Bills Deposited using SUMPRODUCT function. If you want to learn how SUMPRODUCT calculates, this is a good example.

  • likes, 0 dislikes

Link to this comment:

Share to:

Uploader Comments (ExcelIsFun)

  • awesome trick

    Thanks so much mike

    I miss Mr excel video too

    Please youtube do something

    Please restart Mr Excel Account Again

    Please please please

    Mike you are Genus too

    I enjoy your video always

    Thanks God bless you :-)

  • Thanks!

    But I am no Genus -- I am just a guy having fun with Excel!!!

  • Hiya Mike :P. I suppose you remember me? Haven't been on your videos in a while, I've become a devout follower to JPizzle1122's "Is it a good idea to microwave this", among other things, such as enjoying the snow, gaming and facebook, but I thought I'd drop in and say hi! :).

    This looks like a very interesting formula! I hadn't known what it was before ... thanks for finding an awesome analogy to explain it! I have rather missed your epic voice lol.

    Oh, and what came of dear old Mr Excel?

  • Imagine an epic voice...

    Happy New Year!

    For Mr Excel, see this video title:

    Mr Excel Banned From YouTube

  • @ExcelIsFun

    I have, that's why I was asking :P. I just wanted to know if there's any news on his account.

  • As sonn as there is news I will make a video!

see all

All Comments (7)

Sign In or Sign Up now to post a comment!
  • I wish Bill the best of luck :P.

Loading...

Alert icon
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