if then statement

[Guest]

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

 

[Bob Phillips]

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

 

[Guest]

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]

What happens if more than one?

 

[Guest]

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

 

[Bob Phillips]

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.

 

[Guest]

Dear DG,

Try this array formula (Ctrl+Shift+Enter)

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

Regards,

Ashish