Home |
Search |
Today's Posts |
#1
|
|||
|
|||
SUMIF function question
Hi guys,
I am trying to count the instances between 15 minutes periods. For example my data is: 12:05:34 12:11:45 12:12:12 12:14:43 12:15:59 I want my function to calculate how many instances there are between 12:00:00 am and 12:15:00 am. (for the above data it would be 4). Can anyone help me? Thanks! khux |
#2
|
|||
|
|||
SUMIF function question
Let's assume your data is stored in cells A1:A5.
=COUNTIF(A1:A5,"=12:00:00")-COUNTIF(A1:A5,"12:15:00") This calculation may change the format of the cell to display time, so in that case you'd need to change the format back to General (or whatever you need). HTH, Elkar "khux" wrote: Hi guys, I am trying to count the instances between 15 minutes periods. For example my data is: 12:05:34 12:11:45 12:12:12 12:14:43 12:15:59 I want my function to calculate how many instances there are between 12:00:00 am and 12:15:00 am. (for the above data it would be 4). Can anyone help me? Thanks! khux |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to nest a left function within a sumif function? | Excel Worksheet Functions | |||
How do I use the TODAY function with the SUMIF function? | Excel Worksheet Functions | |||
Array Function Question | Excel Worksheet Functions | |||
Dynamic Function Reference Question | Excel Discussion (Misc queries) | |||
How to combine a vlookup with a sumif function!!! | Excel Discussion (Misc queries) |