+ Reply to Thread
Results 1 to 3 of 3

Count if date is between two dates and value in another column equ

  1. #1
    mg_sv_r
    Guest

    Count if date is between two dates and value in another column equ

    Hi,

    Don't know if this is possible but I have a large spreadsheet that details
    'problem transactions'.

    From this spreadsheet I want to count the number of rows where the date is
    between two set dates and the value in another column equals a certain value.

    For example, suppose column 'A' contains the date and column 'F' contains
    other data. I want to use a formula to count the number of rows where Column
    'A' is between 01/01/2000 and 31/01/2000 and column F equals 'ABCDEF'.

    Is this possible?

    Thanks in advance for any help, sorry if this is not very clear.

  2. #2
    JE McGimpsey
    Guest

    Re: Count if date is between two dates and value in another column equ

    One way:

    Assume your start date is in J1 and your end date in J2:

    =SUMPRODUCT(--(A1:A1000>=J1),--(A1:A1000<=J2),--(F1:F1000="ABCDEF"))


    In article <99EBBFA0-8C6A-41B7-886A-C2323E9B6BEB@microsoft.com>,
    "mg_sv_r" <mgsvr@discussions.microsoft.com> wrote:

    > Hi,
    >
    > Don't know if this is possible but I have a large spreadsheet that details
    > 'problem transactions'.
    >
    > From this spreadsheet I want to count the number of rows where the date is
    > between two set dates and the value in another column equals a certain value.
    >
    > For example, suppose column 'A' contains the date and column 'F' contains
    > other data. I want to use a formula to count the number of rows where Column
    > 'A' is between 01/01/2000 and 31/01/2000 and column F equals 'ABCDEF'.
    >
    > Is this possible?
    >
    > Thanks in advance for any help, sorry if this is not very clear.


  3. #3
    Bob Phillips
    Guest

    Re: Count if date is between two dates and value in another column equ

    =SUMPRODUCT(--(A2:A200>=--"2000-01-01"),--(A2:A200<=--"2000-01-30"),--(F2:F2
    00="ABCDEF"))

    --

    HTH

    RP
    (remove nothere from the email address if mailing direct)


    "mg_sv_r" <mgsvr@discussions.microsoft.com> wrote in message
    news:99EBBFA0-8C6A-41B7-886A-C2323E9B6BEB@microsoft.com...
    > Hi,
    >
    > Don't know if this is possible but I have a large spreadsheet that details
    > 'problem transactions'.
    >
    > From this spreadsheet I want to count the number of rows where the date is
    > between two set dates and the value in another column equals a certain

    value.
    >
    > For example, suppose column 'A' contains the date and column 'F' contains
    > other data. I want to use a formula to count the number of rows where

    Column
    > 'A' is between 01/01/2000 and 31/01/2000 and column F equals 'ABCDEF'.
    >
    > Is this possible?
    >
    > Thanks in advance for any help, sorry if this is not very clear.




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1