The formulas you will need to employ will need to be COUNTIFS() (to get a total count of how many donations exist for a single person in a specific date range, and SUMIFS() to get the $ amounts.
For example, assuming column A is names, B is dates and C is donation amount:
=COUNTIFS(A:A, "John Doe", B:B, ">=1/1/2015", B:B, "<=12/31/2015")
=SUMIFS(C:C, A:A, "John Doe", B:B, ">=1/1/2015", B:B, "<=12/31/2015")
Also, a PIVOT TABLE will do this for you automatically.
Bookmarks