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.  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
  2. ccm81
    Hello

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

    Best regards
    0