Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

subtotals in Excel

Status
Not open for further replies.

CCNProjects

Technical User
Nov 4, 2005
64
CA
Dear all:

I have a huge table, and i would like to compute subtotals by year. this is my data.
1989 12 E 1605102025 1220 1 686 1839 0
1989 12 E 1605102025 1220 7 3810 22518 0
1989 12 E 1605104010 5880 30 20000 112504 0
1990 1 E 1605104005 1220 2 17690 196382 0
1990 1 E 1605104005 5800 27 17561 159782 0
1990 1 E 1605104010 5490 10 239 1485 0


I looked in the help provided by Excel, but did not go anywhere with it!
Could you tell me how to do it?
Thanks.
 




Check out Data > Subtotal wizard.

Skip,

[glasses] When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large[tongue]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top