Dynamically Populate Sum by Dates

Question

I'm hoping someone can help me build a quick function in Excel or an auto-populated table which sums an amount based upon what sales were done on a daily basis.

Example Table:

--------------------------------------------------
date    |   gross amt.
------------------------------
1/1/14  |  $200
1/1/14  |  $100
1/1/14  |  $300
1/4/14  |  $999
1/7/14  |  $500
1/13/14 |  $100

Table that will need to be created

--------------------------------------------------
date    |   total amount  |  # entries
------------------------------
1/1/14  |  $600   |   3
1/4/14  |  $999   |   1
1/7/14  |  $500   |   1
1/13/14 |  $100   |   1

For such a simple table I obviously can use a SUM function and just type the dates on which sales occur. Unfortunately, I have numerous tables where some may have 50 entries on one date yet 2 on another date, or 2 on one date and 50 on another.

I was thinking of some sort of dynamic range but would like to know, what would be a sensible approach?

Answer 1

Something like this would appear may be of use: