Results 1 to 2 of 2

COUNTIFS is counting my blank, text fields

Threaded View

  1. #1
    Registered User
    Join Date
    08-18-2011
    Location
    Denver Colorado
    MS-Off Ver
    Excel 2007
    Posts
    65

    COUNTIFS is counting my blank, text fields

    I'm trying to use the COUNTIFS function to count items based on a date (column H), either 7 days before action is due, or at or more than 30 days. There are also two other variables to the function. If column I is "Y", then don't count H. If column J is a date, then don't count H. My problems are: it's counting blank cells in H (" " as a formula result) and it's not decreasing the count for entries in I or J.

    Here's the last entry I tried
    =COUNTIFS(H:H,"<B2-7",H:H,"<>" & " ",I:I,"<> Y",J:J,"<> 0")

    I'm out of ideas.
    Attached Files Attached Files
    Last edited by NBVC; 01-02-2012 at 01:20 PM. Reason: Mark Solved Per PM Request

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