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!

  • I think I like the last array formula. Quick and easy. Thanks Mike.

    krn14242 1 year ago

  • Me too!

    Technically it is not an array formula because it does not use Ctrl + Shift + Enter. The last formula contains an "array constant" but it does not require Ctrl + Shift + Enter.

    However, one problem with the last one is that you are hard coding the criteria into the formula. If you don't want to do that, I like the first one COUNTIF + COUNTIF. That is why I teach the COUNTIF + COUNTIF.

    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