Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum if less than and more than a time range
I have a nested if formula, where I am looking for the total of the values in
a range of cells which match 4 ranges of criteria. Total number in cells listed as "FB" and "ME" less than 0.067 (time) and more than 0.167 (time). The lists are on a seperate worksheet. I can get the sum to work with 3 criteria, ie. only less than time in one formula and more than time in another, but not with both. Any help would be appreciated as I am a novice at this. Here is my formula for one time frame. =SUM(IF(IMPORT!$Q$2:$Q$86="FB",IF(IMPORT!$Z$2:$Z$8 6="ME",IF(IMPORT!$A$2:$A$86<=0.167,IMPORT!$I$2:$I$ 86,0),0),0))+SUM(IF(IMPORT!$R$2:$R$86="FB",IF(IMPO RT!$Z$2:$Z$86="ME",IF(IMPORT!$A$2:$A$86<=0.167,IMP ORT!$I$2:$I$86,0),0),0))+SUM(IF(IMPORT!$S$2:$S$86= "FB",IF(IMPORT!$Z$2:$Z$86="ME",IF(IMPORT!$A$2:$A$8 6<=0.167,IMPORT!$I$2:$I$86,0),0),0) I am looking for <0.067 and 0.167 in the range IMPORT!$I$2:$I$86. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time to time range formula??? | Excel Worksheet Functions | |||
Converting time to a range of time | Excel Discussion (Misc queries) | |||
Convert time to time range | Excel Discussion (Misc queries) | |||
Date Range for my time sheet | Excel Worksheet Functions | |||
How do you sum a range of more than 30 cells. I get error each time I try. | Excel Worksheet Functions |