CountIF

[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

 

[Frank Kabel]

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

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