I have a sheet where I have the following data:
<tbody>
</tbody>
I want to count how much unique id's are registered in a specific timeframe. To count the unique ID's I use =SUM(IF(FREQUENCY(A:A;A:A)>0;1;0)), which works.
But if then want to add the date inbetween i.e. 141073300 - 141078200 I get lost.
I found as result =SUM(IF(FREQUENCY(A:A;A:A)>0;(B:B>=D5)*(B:B<D37);0)) Where D5 and D37 refer to the cell that the value 141073300 and 141078200 are in.
But this doesn't work...
Does someone know what to do?
ID | Date |
3414 | 141073200 |
3414 | 141073941 |
3501 | 141077892 |
3508 | 141077999 |
3509 | 141078011 |
3509 | 141078191 |
3580 | 141078192 |
<tbody>
</tbody>
I want to count how much unique id's are registered in a specific timeframe. To count the unique ID's I use =SUM(IF(FREQUENCY(A:A;A:A)>0;1;0)), which works.
But if then want to add the date inbetween i.e. 141073300 - 141078200 I get lost.
I found as result =SUM(IF(FREQUENCY(A:A;A:A)>0;(B:B>=D5)*(B:B<D37);0)) Where D5 and D37 refer to the cell that the value 141073300 and 141078200 are in.
But this doesn't work...
Does someone know what to do?