Results 1 to 2 of 2

Thread: help with excel

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. 10-26-2005, 07:07 AM #1
    roger
    roger is offline
    VBAX Newbie
    Joined
    Oct 2005
    Posts
    1
    Location

    help with excel

    I have a question about an excel project.

    I need to track information for specific dates.

    As an example I have a column of dates 1/02/05 and a column of pass or fail, what I need to do is compare the amount of pass and fails for each month. Like for the month of January I want to know how many failures I had.

    Any help with this would be appreciated.
    Reply With Quote Reply With Quote
  2. 10-26-2005, 07:25 AM #2
    Bob Phillips
    Bob Phillips is offline
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,455
    Location
    =SUMPRODUCT(--(MONTH(A1:A100)=1),--(B1:B100="Fail"))
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules