I am working on a stat log that needs to provide daily, weekly and monthly
totals for each staff member.

I need excel to sum the dollar amouts in P6:P1000 (for each worksheet) if the
date in A6:A1000 is a particular date (ex: 4/1/10).

I have tried several different functions/formulas and I have not received
the response I am looking for.

Thanks in advance for your help!
Desireé