Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jul 2005
    Location
    Bahrain
    Posts
    373
    Thanks
    1
    Thanked 0 Times in 0 Posts

    special count formula (excel2003)

    hi all,
    the attached file represents a sample of my data and explains my request, I won count based on three conditions, first, match of the name(col. I) with name(col. A), second, if the flaq is either "NPLAN" and/or "PLAN", column D and third, if the menu column c is in the defined list SMENU, column f. Please note the SMENU could have more than 4.

    Regards,
    dubdub
    Attached Files Attached Files
    TIA
    dubdub

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: special count formula (excel2003)

    Try this in J2, adjust the ranges as necessary, and fill down:

    =SUMPRODUCT(($A$2:$A$15=$I2)*(($D$2:$D$15="PLAN")+ ($D$2:$D$15="NPLAN"))*ISNUMBER(MATCH($C$2:$C$15,$F $2:$F$5,0)))

  3. #3
    3 Star Lounger
    Join Date
    Jul 2005
    Location
    Bahrain
    Posts
    373
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: special count formula (excel2003)

    many thanks HansV, i will as soon i get back to office.
    Regards,
    dubdub
    TIA
    dubdub

Posting Permissions

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