If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Daily totals from a monthly log
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Ʃ |
#2
|
|||
|
|||
Daily totals from a monthly log
Assuming you have sheet name as: Sheet1, Sheet2, and Sheet3
=SUMPRODUCT(SUMIF(INDIRECT("Sheet"&ROW(1:3)&"!A6:A 1000"),"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Ʃ |
Thread Tools | |
Display Modes | |
|
|