Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Perth, Western Australia, Australia
    Posts
    487
    Thanks
    75
    Thanked 2 Times in 1 Post
    Loungers,

    Please see the attached file- I'm using a formula (that I found on the web) for counting months. However, as can be seen in the attached file, when I extend the range to count Jan (column D), it also counts the blank cells, however this does not happen when I extend the range to count Feb.

    Any thoughts on how I can resolve this problem?
    Attached Files Attached Files

  2. #2
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Your formula is evaluating the blank cells as the month for day 0 (zero), which according to excel would be Jan 0, 1900.

    another formula option would be:
    Code:
    =SUMPRODUCT((MONTH($A$2:$A$24)=MONTH(C2))*($A$2:$A$24<>"")*1)

  3. #3
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Perth, Western Australia, Australia
    Posts
    487
    Thanks
    75
    Thanked 2 Times in 1 Post
    Mike - thanks for that.

    Problem fixed!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •