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 réponses

Réponse 1 / 2
ccm81 Posted messages 11033 Status Membre 2 434
 
Hello

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

Best regards
0
Réponse 2 / 2
Vaucluse Posted messages 27336 Registration date   Status Contributeur 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
mamounette17
 
Thank you, my spreadsheet is working!
0