Sort by time | Sort by thread (beta)

Link to this comment:

Share to:

All Comments (4)

Sign In or Sign Up now to post a comment!

  • this look more to counting but how to sum the qty to get total number?

    yuenmxk 1 year ago

  • If you wnat to add the B column, use:

    =SUMPRODUCT(--(YEAR(A2:A10)=D3­),B2:B10)

    ExcelIsFun 1 year ago

  • Perhaps some better error responses would help as well. :)

    krn14242 1 year ago

  • That is for sure!

    ExcelIsFun 1 year 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