CountIF

C

conny80

Hey,
I am trying to use the CountIF worksheet funktion on multipl
conditions.
In my formula I have got a column A1:A10 and whenever Excel find th
letter "U" there, it then should checks for the text "Carter" in th
same row in column C (the range C1:C10). And Excel should then give m
the aggregated numbers for "U" which have the name "Carter" in colum
C.

Is COUNTIF the right function therefore?
Thanks, Conn
 
F

Frank Kabel

Hi
try
=SUMPRODUCT((A1:A10="U")*(C1:C10="Carter"))

or
=SUMPRODUCT(--(A1:A10="U"),--(C1:C10="Carter"))
 
Top