Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Average With < Continued | Excel Worksheet Functions | |||
Median continued | Excel Discussion (Misc queries) | |||
Pivot Totals: Group totals different from Grand totals | Excel Discussion (Misc queries) | |||
If then statement continued! | Excel Discussion (Misc queries) | |||
Finding Totals...Continued | Excel Programming |