auto sum a different column and end at the first blank cell

[dawondr]

Hi,
I have a very basic sheet that I use to track my forecast each month. It is an evolving doc meaning I just add the next month to the sheet so I also have a log of what I had in the past.
If you can look at the attached example, you will see there is no set number of entries for a given month. I'm wondering if I can automatically have the new month I add also create an autosum for that month. I am very flexible where that information can be shown. Yellow or blue cell would be best but I'd even be happy even if it was in the green cell and summed down instead of up. (this will make sense when u see the sheet).
If it is more than a couple of keystrokes just tell me that it is more work then the benifit of automating and I'd be fine with that answer too, autosumming is easy enough that I can manually do it each month but I think I'm just missing something here in automating the step.

Thx in advance for your time,

Dave

[dilipandey]

Hi Dave,

If you have months repeated, you can use SubTotal function.

Look for this function help in Excel help. thanks.



Regards,
DILIPandey
<click on below * if this helps>

[dawondr]

Thank you, I did read it just now (I'm using Excel 2007 by the way). I'm still not clear on how I would tell it to subtotal a rainge in another column and that rainge has not even been defined yet. I'm thinking it will need to be triggered bu the addition on a new month in column A. In my real worksheet, column a is a validation list. I know I can make a validation list dependent to another validation list but can I run a formula like subtotal by adding something from a validation list in another cell?

[dilipandey]

Okay.. see the new sheet on right side sheet 1 (2).

removed extra blank rows, and filled up the formula at once in column A and then applied subtotal... let me know if this is fine and I can guide you step by step.

autosum question.xlsx

Regards,
DILIPandey
<click on below * if this helps>

[dawondr]

Sorry for the delay in my reply, I was feeling under the weather for a few days. This is exactly what I was trying to do. I added a row in the middle of January and it revised your sub total. This was perfect. I also appriciate your offer to showe me how but first I want to see if I can figure out how based on how you have it working. I learn better by doing it that way. Thank you again!

Dave

[dilipandey]

you are welcome Dave..

cheers


Regards,
DILIPandey
<click on below * if this helps>