Results 1 to 3 of 3

Excel 2007 : Problem IF and COUNTIFS formula

Threaded View

  1. #1
    Registered User
    Join Date
    02-23-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2007
    Posts
    50

    Problem IF and COUNTIFS formula

    Hi,
    Am trying to count unique names from a list which match a specific criteria and returns 1. Ive summarised below with a detailed example attached
    col_A: name
    col_B: dd/mm/yyyy (date)
    col_C: formula
    =IF(B2="","Blank",TEXT(B2,"mmm-yy"))
    col_D: formula
    =IF(COUNTIFS($A$2:A2,A2,$C$2:C2,"Feb-11")=1,1,"0")
    However, for certain names I get double counts in col_D. I think the problem is to do with the dates in col_B, when they are the same but one month out i.e. 14/02/11 and 14/03/11 (and only for Mar never for Jan) I get a duplicate counts but I cant find a way around it.

    Your help would be much appreciated!
    Thanks
    Attached Files Attached Files
    Last edited by tiger01; 02-23-2011 at 05:30 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