| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing rows based on column headings
Yes, we are antiquated and using basic Excel ss to do our job costing. I'm
hoping there is a function of which I am not aware which will help me out. Excel We have columns for the months, Jan-Dec, and rows for the types of cost. Values are either actuals or forecasts, based on the month (column heading). I want to be able to open the ss in March, and the function realizes Jan & Feb 2006 are prior to March, so it sums the Jan & Feb rows on the left, those being my actuals. I then just total all the rest and subtract the actuals to get my remaining forecast. Please let me know if you know of a way to do this. Leslie |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Summing rows based on column headings
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with copying dynamic column selected based on remote cell value and dynamic formula fill | Charts and Charting in Excel | |||
| Need to select rows to average based on a value in a different column | New Users to Excel | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| Format cell in column B based on value in the next cell (column c) | Excel Discussion (Misc queries) | |||
Linear Mode
