| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
summing values in a data table based on criteria in another column
I have a data table whose columns are arranged in the following manner, from
left to right: Date | ArriveTime | LeaveTime |Hours | Overtime | Regular | Gross | RunningGross | CumHours | $/Week What I'm looking to do is sum the "Gross" column based on a period of dates, say 8/1/06 through 8/31/06, and not select this range manually. The Date column is column D and the Gross column is column J. Ideas? -- Brevity is the soul of wit. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Create Charts based on data in Table | Charts and Charting in Excel | |||
| Counting & Summing based on criteria on another column | Excel Discussion (Misc queries) | |||
| Lookup Table Dilemma | Excel Worksheet Functions | |||
Threaded Mode
