|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 25th, 2010, 10:42 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
sumif
I need to add the total in cell H6 if the following condition is met If H60 and A6 contains the word "total" (where A6 can contain alpha and numbers) i.e. the formula must only find the total if a6 contains the word "total" and not if it simpy contains other figures or alpha is this possible? -- Barny 
|
|
#2
February 25th, 2010, 02:40 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
sumif
This is only a sample:
=IF(A6="total",SUM(H1:H5),"something else") -- Gary''s Student - gsnu201001 "Barny" wrote: I need to add the total in cell H6 if the following condition is met If H60 and A6 contains the word "total" (where A6 can contain alpha and numbers) i.e. the formula must only find the total if a6 contains the word "total" and not if it simpy contains other figures or alpha is this possible? -- Barny .
|
|
#3
February 25th, 2010, 03:18 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
sumif
Hi,
=if(and(H60,A6="Total"),sum(H1:H5)) "Barny" wrote: I need to add the total in cell H6 if the following condition is met If H60 and A6 contains the word "total" (where A6 can contain alpha and numbers) i.e. the formula must only find the total if a6 contains the word "total" and not if it simpy contains other figures or alpha is this possible? -- Barny .
|
|
#4
February 25th, 2010, 09:45 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
sumif
Eduardo;931678 Wrote: Hi, =if(and(H60,A6="Total"),sum(H1:H5)) "Barny" wrote: - I need to add the total in cell H6 if the following condition is met If H60 and A6 contains the word "total" (where A6 can contain alpha and numbers) i.e. the formula must only find the total if a6 contains the word "total" and not if it simpy contains other figures or alpha is this possible? -- Barny . - This works if A6 just contains total but sometimes teh cell will contain the word Total and numbers so i need to specify that the formula can work in both scenarios - thanks for help -- Barny
|
|
#5
February 27th, 2010, 01:41 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
sumif
=IF(ISERR(SEARCH("total",A6)),"",SUM(H2:H5))
-- Don Guillett Microsoft MVP Excel SalesAid Software "Barny" wrote in message ... Eduardo;931678 Wrote: Hi, =if(and(H60,A6="Total"),sum(H1:H5)) "Barny" wrote: - I need to add the total in cell H6 if the following condition is met If H60 and A6 contains the word "total" (where A6 can contain alpha and numbers) i.e. the formula must only find the total if a6 contains the word "total" and not if it simpy contains other figures or alpha is this possible? -- Barny . - This works if A6 just contains total but sometimes teh cell will contain the word Total and numbers so i need to specify that the formula can work in both scenarios - thanks for help -- Barny
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
