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é

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)&"!P6:P1000")))



"Dhardy" wrote:

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