subtraction in subtotals?

[bfeist]

How do I use the subtotals function to subtract a group of numbers with the same name in excel 2003? for a simple example:

dog 10
dog 7
cat 4
cow 24
horse 2
horse 4

i want it to say dog total 3, cat total 4, cow total 24, horse total -2, ect.. right below each change in name just like subtotals does.
if subtotals is not possible, what function can i use that will subtract the numbers if the name is the same and if the name is not the same then just print the number in the cell? when there are 2 names though i want it to skip that first cell and print the subtraction total in only the 2nd row. another simple example:

dog 10
dog 7 3
cat 4 4
cow 24 24
horse 2
horse 4 -2

 

[Weaver]

Is there always 2 of each and are they always together, like the example

 

[Peter_SSs]

How do I use the subtotals function to subtract a group of numbers with the same name in excel 2003? for a simple example:

dog 10
dog 7
cat 4
cow 24
horse 2
horse 4

i want it to say dog total 3, cat total 4, cow total 24, horse total -2, ect.. right below each change in name just like subtotals does.
if subtotals is not possible, what function can i use that will subtract the numbers if the name is the same and if the name is not the same then just print the number in the cell? when there are 2 names though i want it to skip that first cell and print the subtraction total in only the 2nd row. another simple example:

dog 10
dog 7 3
cat 4 4
cow 24 24
horse 2
horse 4 -2

Welcome to the MrExcel board!

For the second choice, try this formula (copied down).

Excel Workbook
	A	B	C
1	Type	Number
2	dog	10
3	dog	7	3
4	cat	4	4
5	cow	24	24
6	horse	2
7	horse	4	-2
8
Subtract

 

[bfeist]

Thank you sooo much!! I have over 50,000 cells so this saves me time and my sanity You guys are great!!