| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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é |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW DO I FREEZE DATA THAT CHANGES DAILY. dAILY/MONTHLY BUDGET | Excel Discussion (Misc queries) | |||
| Summing Weekly Totals into Monthly Totals | Excel Worksheet Functions | |||
| Collecting weekly and monthly totals from daily data | Excel Worksheet Functions | |||
| Daily,monthly total | Excel Discussion (Misc queries) | |||
| How do I sum YTD totals based on monthly totals | Excel Discussion (Misc queries) | |||
Linear Mode
