View Single Post
  #3   Report Post  
DG
 
Posts: n/a
Default

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