Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if with or condition
Dear All,
i have the series of time in coloumn. I want to sum only that times duration which are less then 10 min. or more then 5 min. all other will be count as zero. Thanks & regards |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if with or condition
Try:
=SUMIF(A1:A30,"="&TIME(0,5,))-SUMIF(A1:A30,""&TIME(0,10,)) -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Hassan" wrote in message ... Dear All, i have the series of time in coloumn. I want to sum only that times duration which are less then 10 min. or more then 5 min. all other will be count as zero. Thanks & regards |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if with or condition
Try this
=SUMIF(A1:A19,""&TIME(0,5,0))-SUMIF(A1:A19,""&TIME(0,10,0)) Mike Bothe formatted correctly as time Mike "Hassan" wrote: Dear All, i have the series of time in coloumn. I want to sum only that times duration which are less then 10 min. or more then 5 min. all other will be count as zero. Thanks & regards |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if with or condition
=SUM(SUMIF(A:A,{"0:05:00","=0:10:00"})*{1,-1})
"Hassan" wrote: Dear All, i have the series of time in coloumn. I want to sum only that times duration which are less then 10 min. or more then 5 min. all other will be count as zero. Thanks & regards |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if with or condition
Hi TM,
I didn't know you could give multiple criteria to SUMIF (and COUNTIF, I discovered). XL seems to deal with your formula as an array formula, but doesn't need to be array entered. Always learning. Regards - Dave. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
if condition | Excel Worksheet Functions | |||
lookup with multiple condition, but one condition to satisfy is en | Excel Worksheet Functions | |||
Combine an OR condition with an AND condition | Excel Discussion (Misc queries) | |||
Condition 1 overules condition 2? | Excel Worksheet Functions | |||
How to set condition: A1=A2=A3= ... =A10 | Excel Worksheet Functions |