Excel Magic Trick 406: Add 1 Extra For Each Deposit
1:26
Added: 2 years ago
From: ExcelIsFun
Views: 1,405
Sort by time | Sort by thread (beta)

Link to this comment:

Share to:

All Comments (2)

Sign In or Sign Up now to post a comment!

  • Mike, EMT406 displays an array formula versus sum + count you describe in the video.

    krn14242 2 years ago

  • Thnaks for letting me know! I will post the correct workbook tomorrow. The formula in the video is much better than the one in the downloaded workbook.

    ExcelIsFun 2 years ago

  • Ooh, that's a very interesting one :D. Seems simple enough too, I thought this would be massively complicated like the OFFSET function, but it seems really easy.

    Mynotoar 2 years ago

  • The funny thing is that when I first came up with an answer, I did a complicted array formula and then I went, Duh.

    SUM + COUNT

    ExcelIsFun 2 years ago

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