Results 1 to 3 of 3

COUNTIF with two conditions

Threaded View

firebladejr COUNTIF with two conditions 04-23-2008, 08:38 PM
firebladejr ok, I made a new column (I)... 04-24-2008, 12:26 AM
Richard Buttrey Hi, I'm attaching a sample... 04-24-2008, 09:35 AM
  1. #2
    Registered User
    Join Date
    09-03-2007
    Posts
    12
    ok, I made a new column (I) which contains the result of 'current date' - 'start date'. Hopefully this will help.. My problem is with the below expression..

    =COUNT(IF(I:I,"<30"),(IF(A:A,"1")))
    for some reason I always get a result of '2'
    Last edited by firebladejr; 04-24-2008 at 12:29 AM.

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