if a:a contains "*Total Tele*", then add C:C if C:C is <24

=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

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

What happens if more than one?

--
HTH

Bob Phillips

"DG" wrote in message
...
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

The answer to your response is that it counts all the cells that are <24 in
column c (third coloumn)


I have this section repeated for 100 locations in the same sheet. What i
need to to count the cell in the third column that is in the row that
contains Total telephone port when it is less than 24. This particular
location has 300.

Total Telephone Ports 288 300
High End Telephones 75 75
Standard Telephones 143 155
Low End Telephones 25 25
Receptionist Telephones 20 20
Fax Ports 25 30

Okay

=SUMPRODUCT(--(ISNUMBER(FIND("Total Tele",A1:A100))),--(C1:C100<24),C1:C100)

but this will return 0 not 300 using the data you show because the C value
is 24.

--
HTH

Bob Phillips

"DG" wrote in message
...
The answer to your response is that it counts all the cells that are <24
in
column c (third coloumn)


I have this section repeated for 100 locations in the same sheet. What i
need to to count the cell in the third column that is in the row that
contains Total telephone port when it is less than 24. This particular
location has 300.

Total Telephone Ports 288 300
High End Telephones 75 75
Standard Telephones 143 155
Low End Telephones 25 25
Receptionist Telephones 20 20
Fax Ports 25 30

Dear DG,

Try this array formula (Ctrl+Shift+Enter)

=sum(if((range="*Total Tele*")*(range<24),sumrange))

Regards,

Ashish

"DG" wrote:

if a:a contains "*Total Tele*", then add C:C if C:C is <24