Bob that did work and was what i asked for, Thank you.
How would i count only the row that contained the Total Tele based on that
formula.
"Bob Phillips" wrote:
=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
|