Summing rows based on column headings

G

Guest

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
 
G

Guest

I can e-mail you a little workbook..that you can modify...

(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sort headings? 1
Serious help needed for this project Can anyone help me with this 7
Forecasting with formulas HELP 1
Summing rows based on other column values 7
Conditional SUM for Budget, Actuals, & Variance YTD columns 0
Sum every 6th cell in a row. 3
how do I average only certain cells based on month? 3
Look up based on Column and Row headings 4

Top