Daily totals from a monthly log

[Dhardy]

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 P61000 (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é

 

[Teethless mama]

Assuming you have sheet name as: Sheet1, Sheet2, and Sheet3

=SUMPRODUCT(SUMIF(INDIRECT("Sheet"&ROW(1:3)&"!A6:A1000"),"4/1/10",INDIRECT("Sheet"&ROW(1:3)&"!P61000")))