Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Nov 2001
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Count IF statement (Excel 2000)

    In column B, I have either a "F" or a "M". In column D, I have an "X" to denote an advanced row. I would like to count the number of X's in for the "F" rows. How do I write the if statement to count this.

  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

    Re: Count IF statement (Excel 2000)

    Array formula (confirm with ctrl-shift-enter)
    =COUNT(IF((D11000="X")*(B1:B1000="F"),1))

    Change ranges as appropriate. (NOTE: you can NOT use the entire column in ARRAY formulas)

    Steve

  3. #3
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Tampico, Tamps, Mexico
    Posts
    118
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Count IF statement (Excel 2000)

    This is a simple formula, is not array:

    =SUMPRODUCT((B1:B1000="F")*(D11000="X")*1)

Posting Permissions

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