Daily totals from a monthly log

D

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top