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

Excel Magic Trick 457: SUMPRODUCT & OR Criteria

Loading...

Sign in or sign up now!
1,931
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Nov 30, 2009

See how to count all the Fridays and Mondays in a list of dates using the SUMPRODUCT function and the OR criteria plus symbol +. See the TEXT and WEEKDAY functions. Learn how the COUNTIF function will not work because COUNTIF does not handle arrays

  • likes, 1 dislikes

Link to this comment:

Share to:
see all

All Comments (3)

Sign In or Sign Up now to post a comment!
  • Here is a third one:

    Excel Formula Efficiency 1: SUMPRODUCT function 12 Examples

  • I have many videos. Here are a few titles you can search for:

    Excel Magic Trick 314: Convert TRUE & FALSE to 1 and 0

    Highline Excel Class 37: SUMPRODUCT function

    Highline Excel Class 37: SUMPRODUCT function

  • Do you happen to have a video about the double negatives?

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