View original (French)

Count the crosses

Solved
mamounette17 -  
Hello,
I can't find the formula to count the number of crosses in my column C but only those that have 25 in column A.
Thanks for the help!

Configuration: Windows 7 / Mozilla 11.0

2 answers

  1. ccm81
    Hello

    C1=SUMPRODUCT(($B1:$B1000="x")*($A1:$A1000=25))

    Best regards
    0
    1. Vaucluse Contributor
      Hello

      Excel 2007 or later:

      =COUNTIFS(A:A, 25, C:C, "X")

      before 2007

      =SUMPRODUCT((A1:A1000=25)*(C1:C1000="X"))

      (Row numbers are mandatory with this code)

      cheers

      --
      To err is human, to persist is diabolical
      0
      1. mamounette17
        Thank you, my spreadsheet is working!
        0