• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. M

    Sumproduct - counting dates in a datetimelist

    i'm having an issue trying to count the number items in a list occurring on a given date. =SUMPRODUCT(--(List!$S:$S=$A$1)) where column S is a datetime list and $A$1 is the date i am looking for. i only get 0, i think it is an issue counting a date in a datetime list, but i'm not sure? thanks
Back
Top