sumif

[Barny]

I need to add the total in cell H6 if the following condition is met

If H6<>0 and A6 contains the word "total" (where A6 can contain alph
and numbers) i.e. the formula must only find the total if a6 contain
the word "total" and not if it simpy contains other figures or alpha

is this possible

 

[Gary''s Student]

This is only a sample:

=IF(A6="total",SUM(H1:H5),"something else")

 

[Eduardo]

Hi,
=if(and(H6<>0,A6="Total"),sum(H1:H5))

 

[Barny]

Hi,
=if(and(H6<>0,A6="Total"),sum(H1:H5))

:
-

This works if A6 just contains total but sometimes teh cell wil
contain the word Total and numbers so i need to specify that th
formula can work in both scenarios - thanks for hel

 

[Don Guillett]

=IF(ISERR(SEARCH("total",A6)),"",SUM(H2:H5))