Results 1 to 3 of 3

Thread: Using countifs

  1. #1
    4 Star Lounger
    Join Date
    May 2002
    Posts
    410
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Using countifs

    I would like to use the following formula and replace the dates with a cell reference.
    =COUNTIFS(Pith_Date,">=1/1/1995",Pith_Date,"<=12/31/1995",Pith_Q,">25")

    What I'd like is something like this:
    =COUNTIFS(Pith_Date,>=A3,Pith_Date,<=B3,Pith_Q,">2 5")

    Possible? I couldn't get it to work.
    It would save me a lot of cell editing if it can be made to work.

    The worksheet is attached

    as always, THANKS!
    Attached Files Attached Files

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    You have to put the non cell in quotes and concatenate:
    =COUNTIFS(Pith_Date,">="&A3,Pith_Date,"<="&B3,Pith _Q,">25")

    If you put 25 in C2 you can use:
    =COUNTIFS(Pith_Date,">="&A3,Pith_Date,"<="&B3,Pith _Q,">"&$C$2)

    You can display the text yoyu have in C2 using the custom number format:
    "Days > "0" cfs"

    Then if you change C2 all the cells will be updated with the new number.

    Steve

  3. #3
    4 Star Lounger
    Join Date
    May 2002
    Posts
    410
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Thanks!

    BTW, your revision turned up an error in my typing in the dates, so DOUBLE THANKS!

Posting Permissions

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