Finding Totals...Continued with Some Data

[LC]

Hi,

I feel like I have confused you before and I would like to
clear some things up.
My previous code was an attempt to do this

Lets say:
A B C D E F G H I J
1 Pets cats 1 23 2 4 23 45 43 23
2 Pets cats 3 4 2 5 67 23 23 23
3 Pets dogs 2 2 3 4 34 23 23 23
4 Pets dogs 4 5 13 4 34 23 23 23

Ok, I would like to insert a new row for the totals of row
1 and 2 and insert another row for the totals of row 3 and
4 and then a new row for totals of all the rows. I have to
use a formula b/c I want the totals to update if the
values were change for cats in either column C to J.

Goal:

A B C D E F G H I J
1 Pets cats 1 23 2 4 23 45 43 23
2 Pets cats 3 4 2 5 67 23 23 23
total for cats...
3 Pets dogs 2 2 3 4 34 23 23 23
4 Pets dogs 4 5 13 4 34 23 23 23
total for dogs
total for Pets

After all this is done, let's say I want to insert a new
row for the total of all cats with white hair within the
rows 1 and 2. Will this mess up the other formulas?

Ok, I hope this clears everything up!
Thank you very much,
LC

 

[steve]

LC,

Excel has a great SubTotal function under the Data menu. Check it out.
I think it will do everything that you are looking for.

Once you have your data sorted by pet type, the function will create
subtotal lines per your criteria.

steve

 

[pancho]

It looks that you only have to use the Subtotals Command
at the Data Menu. maybe you need to add column names on
row 1,then you can select which field change will make the
insertion of row with subtotals.

The last question, will depend on where is the
information, that allow you to question if a pet has white
hair or whatever., So it is difficult to say whitout
knowing the kind of formulas.

But you can include subtotals on areas that already have
subtotals and it function very well, maybe it is the
solution you are looking for



Francisco Mariscal
fcomariscal at hotmail dot com

 

[LC]

Hi Steve,

Thanks for the help, but I am confused of how to use the
subtotal function. For instance, what is this:
TotalList:=Array(8, 9, 10, _
11, 12, 13, 14, 15, 16, 17, 18)

Is there a way to replace those values b/c my C to F
columns will constantly change, i.e. it might be C to Z
next time? Also, I have to find more Subtotals and then a
Grand Total. How can I use the previous subtotal values to
find the grand total?

Thanks.

Will this work well with macros?

 

[LC]

Hi,

I very much like the idea of adding subtotals together.
But how is it possible using VBA?

Oh, I'm sorry, I'm a little new to the Subtotal function.

Thanks alot.