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

Programming in excel


  • Please log in to reply

#1
keepviper13

keepviper13

    New Member

  • Member
  • Pip
  • 7 posts
I have a spreadsheet that i am trying to filter out and sum data from that same row. I want to write a function that will accomplish this task. The spreadsheet is a tracking file that tracks the purchase of parts. Each part has a number which corresponds to where that part will be charged to. There are around 500 different charge numbers and around 5000 parts. I want to write a function that will sum the current balance on each charge number. I can't just sum a certain number of rows either, because the charge numbers are not all row below row, they jump around in the whole file. I figure that i will have to make some sort of "if" statement to pick out the individual charge number and then somehow select the charges from each row and sum them up. How do i write a function that will sum the charges for each charge number. I would like to add another column and place the current balance for each charge number right beside each part ordered. This will then basically be a running balance so that i can see the balance of each charge number beside the part that is purchased.
I've included a screen shot of the basic format of the spreadsheet.

Attached Thumbnails

  • excel_question.jpg

  • 0

Advertisements


#2
keepviper13

keepviper13

    New Member

  • Topic Starter
  • Member
  • Pip
  • 7 posts
somebody have an idea of where to start?
I am pretty confident with a direction i could run with it and figure it out, but i really don't know which functions to try and manipulate to get it to work...
  • 0

#3
Ctrl_Alt_Del

Ctrl_Alt_Del

    Member

  • Member
  • PipPip
  • 74 posts
Have you looked at Pivot Tables? Should make it pretty easy for you.
  • 0

#4
kool808

kool808

    Visiting Staff

  • Member
  • PipPipPipPip
  • 1,690 posts
I do not have a clear statements on your explaination, as what I have understand you mean that a certain charge number corresponds to a certain cost charge, am I right?

can you give us at least 3 examples of equation that you needed to be sorted out? I will have to take patterns on it and make a function for you.
  • 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