Hi everyone,
I am stumped on a particular problem. Right now I have 2 dynamic name ranges "dynvalue" and "dynduration". Dynvalue is comprised of cells containing monetary values from $0.01 and up in no particular order and dynduration is the column next to these monetary values consisting of times in an hh:mm:ss format ranging from 0:00:01 and up, again in no particular order but are relevant to the cell adjacent to it. I am trying to count the number of monetary values for specific time durations.
For example I am trying to get a count of values from $0.01 to $5,000.00 that occured for
1. 5 minutes an under
2. between 0:05:01 and 10 minutes
3. 0:10:01 and over
I can count the number of particular values with
=IF(home="","",COUNTIF(dynvalue, "<$5,000.00"))
This gives me a count of every value under $5,000.00. "home" in the above example is a cell that is either populated or not depending on other things going on. If it is empty the cell this formula is in is blank.
What I can not do is get value counts for the specific time durations mentioned above.
Any help is greatly appreciated.
I am stumped on a particular problem. Right now I have 2 dynamic name ranges "dynvalue" and "dynduration". Dynvalue is comprised of cells containing monetary values from $0.01 and up in no particular order and dynduration is the column next to these monetary values consisting of times in an hh:mm:ss format ranging from 0:00:01 and up, again in no particular order but are relevant to the cell adjacent to it. I am trying to count the number of monetary values for specific time durations.
For example I am trying to get a count of values from $0.01 to $5,000.00 that occured for
1. 5 minutes an under
2. between 0:05:01 and 10 minutes
3. 0:10:01 and over
I can count the number of particular values with
=IF(home="","",COUNTIF(dynvalue, "<$5,000.00"))
This gives me a count of every value under $5,000.00. "home" in the above example is a cell that is either populated or not depending on other things going on. If it is empty the cell this formula is in is blank.
What I can not do is get value counts for the specific time durations mentioned above.
Any help is greatly appreciated.