View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
KL
 
Posts: n/a
Default Need Countif to work like Sumif

Hi Paul,

Try these:

=SUMPRODUCT(--(B7:B203="Paul G"),--(C7:C203<""))
=SUMPRODUCT((B7:B203="Paul G")*(C7:C203<""))

or if apart from non-empty the value in column [C] must be text...

=SUMPRODUCT(--(B7:B203="Paul G"),--ISTEXT(C7:C203))
=SUMPRODUCT((B7:B203="Paul G")*ISTEXT(C7:C203))

Regards,
KL

"paulgallanter" wrote in message ...
I am trying to use the formula =Sumif(B7:B203,"Paul
G",(COUNTIF(C7:C203,"*"))) to count the number of cells in the "C" column
which contains text and are in the same row next to my name in the "B"
column. This formula does not work. Ay suggestions?

Thank you, paul