I cannot figure out why my formula for frequency is not working correctly. Any help is greatly appreciated. I am using this formula for Column B: =FREQUENCY(U:U,A1:A5) and this formula for Column C: =FREQUENCY(U:U,A1).
I am trying to get Column B to give me a total for the times and Column C to give me a cumulative total. I have checked the formatting of all the cells to make sure all are the same, the time formats are the same and just can't seem to figure out the issue. So any help is greatly appreciated.
<tbody>
</tbody>
I am trying to get Column B to give me a total for the times and Column C to give me a cumulative total. I have checked the formatting of all the cells to make sure all are the same, the time formats are the same and just can't seem to figure out the issue. So any help is greatly appreciated.
A | B | C |
1 0:02:00 | 1 | 1 |
2 0:02:20 | 1 | 1 |
3 0:02:40 | 2 | 2 |
4 0:03:00 | 4 | 4 |
5 0:03:20 | 6 | 6 |
<tbody>
</tbody>