| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Thank you for your direction. Much appreciated.
-- SW "JLGWhiz" wrote: Why don't you go ahead and post it in the Worksheet functions group. Someone there who is more familiar with your problem will help you. Just include your current formula and explain what you want to accomplish. Outside the file difference in file extensions, I don't know that there is a lot of difference in the structure of the formula itself. "SW" wrote: Thanks much for your reply. I think I asked for too much. I was mistaken in asking for 'programming' help. I'm actually looking for a fomuala that loos at data in one Work Sheet and transfers the sum to a cell in another work sheet: all within the same Workbook. I've actually got a working formual using Excel 2007 but the school I'm working at only has Excel 2003 so I need to rewrite the formuala. The following is the Excel 2007 formula I'm using: SUMIFS('2003 StarWords.xlsx'!GrandTotal,'2003 StarWords.xlsx'!WeekOf,"1/13",'2003 StarWords.xlsx'!Name,"Abby") I hate to bother you with this but if you can help it would be most appreciated. With Much Respect. Steve -- SW "SW" wrote: I'm looking to add totals that are associated with a specific date in column A (say, 1/13); and a students name in column B (say, Harold). Once those two conditions are met the formula would add the totals of the associated totals found in column C and place that total in a cell in Column D. I'm using Excel 2003. Thanks much for any insight and expertise you may provide. -- SW |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Largest value in column A based on conditions in columns B and C | Excel Worksheet Functions | |||
| Determine a result of one column based on conditions in two column | Excel Discussion (Misc queries) | |||
| counting based on two conditions in excel 2003 | Excel Worksheet Functions | |||
| Excel 2003 Pivot and VBA loop through each record to change cellbackground color based on conditions | Excel Programming | |||
| Formula to Extract value on 3 column based on two conditions | Excel Discussion (Misc queries) | |||
![SW[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
