Excel 2003 running on XP

[jandives]

I have a column of numbers that represent the dyas of a reservation. The
column has a subtotal for the month for the total days rneted that month. Now
year-end, I would like to know the total numbers of night rented for the
year. Is there an easy way to get that (maybe add all the subtotals
together?) without having to create this calculation by hand (like writing
=b12+b17+b23...). I have several spreadsheets to make this calc in and would
like it to be accurate and easy!

Thank you for your help!

 

[Jacob Skaria]

Why dont you post examples of how your data is arranged..?

 

[Dave Peterson]

If you used Data|Subtotal to get those subtotals, you can just use =subtotal()
once more. Heck, even if you added the subtotals yourself, you can use
=subtotal() once more.

=subtotal() will ignore other =subtotal()'s in that range.

If you used =sum(), then you could cheat (I wouldn't!) and just use =sum() once
more, but you'll have to divide by 2.

=sum(a1:a99)/2

I'd try fixing those =sum() formulas:

Select the range
Edit|replace
what: =sum(
with: =subtotal(9,

When you look at excel's help, you'll see that that first number represents what
you want to with the data (average, count, min, max, ...). 9 represents sum.