To Count based on DATE

[karthik013]

Hi,
I would need a help on the scenario mentioned below,
Date Data Date output
12/12/2012 a 12/12/2012 total count of a
12/12/2012 s 12/13/2012 total count of a
12/12/2012 s 12/14/2012 total count of a
12/12/2012 f 12/16/2012 total count of a
12/12/2012 a
12/12/2012 s
12/12/2012 s
12/12/2012 a
12/13/2012 d
12/13/2012 s
12/13/2012 a
12/13/2012 d
12/14/2012 s
12/16/2012 a
12/16/2012 d
12/16/2012 f
12/16/2012 d
12/16/2012 s
12/16/2012 a
12/16/2012 f

The same continues for N number of rows.
Kindly Help

[dilipandey]

Hi karthik,

Try using below formula:-

Please Login or Register  to view this content.

Where C2 is the reference to date of which you need the count of a.

Regards,
DILIPandey

<click on below 'star' if this helps>

[karthik013]

Thanks a lot Dilip..It worked

[dilipandey]

You are welcome Karthik..

Suggest you to mark this thread as [SOLVED].. thanks.

regards,
DILIPandey

<click on below 'star' if this helps>