=IF(COUNTIF(A:A,"*Total Tele*")0,SUMIF(C:C,"<24"),0)


--
HTH

Bob Phillips

"DG" wrote in message
...
if a:a contains "*Total Tele*", then add C:C if C:C is <24