View original (French)

Count the crosses

Solved
mamounette17 -  
 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 Posted messages 11033 Status Member 2 434
     
    Hello

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

    Best regards
    0
  2. Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
     
    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