Excel Spreadsheet

[scottsdaledave]

Is there a template that will sort items and calcaluate totals?

 

[JoAnn Paules]

All Excel files can do that. You may have to plug in a formula but getting a
total is an easy one. Believe me - even I can do that one. ;-)

 

[Echo S]

Is there a template that will sort items and calcaluate totals?

You don't really need a template to sort and total items.

See if this gets you started with learning to sort:
http://office.microsoft.com/en-us/excel/HP052029541033.aspx

And this for calculating totals:
http://office.microsoft.com/en-us/excel/HP030561151033.aspx?pid=CH010005131033

You might also like to check these tutorials on performing simple
calculations with Excel:
http://office.microsoft.com/training/training.aspx?AssetID=RC061079311033&pid=CR061831141033
http://office.microsoft.com/training/training.aspx?AssetID=RC011870911033&pid=CR061831141033

Back to your template question. You can also (kinda sorta) sort columns
using filters. The difference is that filtering temporarily hides rows you
don't want to see, while sorting rearranges the data.
http://office.microsoft.com/en-us/excel/CH062527971033.aspx has good
information on them. I don't know if a template would really help you in
this case, as the sorts and filters are really based on the data in your
spreadsheet. And since it hides rows, it would be confusing to a lot of
users. I guess it's a moot point, because I can't find one anyway!

http://office.microsoft.com/en-us/templates/TC062062751033.aspx?pid=CT101423481033
is an Expense Report template that calculates totals. Lots of the Excel
templates calculate totals. Depending what you're trying to calculate, you
might find something more suitable to your needs by typing search words or
browsing at
http://office.microsoft.com/en-us/templates/FX100595491033.aspx?pid=CL100632981033