Thread
:
Summing rows based on column headings
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Ted
Posts: n/a
Summing rows based on column headings
I can e-mail you a little workbook..that you can modify...
--
Ted
"DallasLDY" wrote:
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
Reply With Quote