Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

excel totals


  • Please log in to reply

#1
dhig3903

dhig3903

    Member

  • Member
  • PipPip
  • 22 posts
I am hoping somebody can tell me how to accomplish what I am trying to do. I have an excel spreadsheet with several pieces of my businesses inventory listed. Each piece of inventory may have 30 rows that make up the total for that piece of inventory. I have a column titled code that designates what each row is (eg - repair, interest, etc). I would like to get a total for each piece of equipment by code and then a grand total for each code for the entire sheet. I have approximately 500 pieces of inventory so needless to say it is a pretty large spreadsheet. Is what I am trying to do possible?

Thanks for any help or advice you can give.


Deanna
  • 0

Advertisements


#2
Ctrl_Alt_Del

Ctrl_Alt_Del

    Member

  • Member
  • PipPip
  • 74 posts
Have you looked at the Subtotal feature under Data on the menu bar?
  • 0

#3
jasonharrod

jasonharrod

    Member

  • Member
  • PipPip
  • 18 posts
Yes, it is possible, if you could zip the spreadsheet and post it up I would be happy to help you with it.
  • 0

#4
jman4001

jman4001

    Member

  • Member
  • PipPip
  • 36 posts
it is certainly possible, excel can do many amazing things... truly a great program, if only 1 person could fully understand every aspect...

try using the "auto-sum" feature. It should be on one of your toolbars. Its the greek letter sigma and can help you preform all sorts of mathematic functions mainly having to do with large amounts of data
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP