+ Reply to Thread
Results 1 to 5 of 5

How to add up products across a row based on a price list?

  1. #1
    Registered User
    Join Date
    08-20-2008
    Location
    Work
    Posts
    4

    Red face How to add up products across a row based on a price list?

    Hello guys & gals I've recently started using Excel at a (well somewhat) new job.
    I've never used it before, even as a quasi manager at my last job...
    So needless to say I need some help Here is a basic layout of what I want to do:

    1) I want to make a sort of "log" where I can track a order #, phone #, etc.
    It will have separate columns for separate products. I want to make it so that
    I can just put the value into each (or multiple) columns and then it totals it at the end of the row.

    2) But, I want to make the values for each column to be hidden...
    So I only see the quantity in each column and then a total at the end of the row.

    Example:

    Order # | Phone # | Product #1 | Product #2 | Total
    ---------
    In this example, #1 is worth $28 and #2 is worth $14 (each).
    So if I want the values (Respectively) '2' & '4' then under the 'Total' column
    I would want the answer of $112

    It is going to be used as a simple order tracker. So I can track the basic information,
    know what was sold and how many, and total dollar amount sold on the order.
    At the bottom (say like row 300 ish) I would tally up the sum of the 'total' column.
    But I've already figured out that part Its just calculating each row individually...
    I hope I was clear. If not, I can upload the excel file I am working with now.

    Any help would be appreciated
    Last edited by JonathanSQ; 08-20-2008 at 11:17 PM. Reason: editing title
    Thanks,
    - Jonathan

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,903
    Here is one possibility:
    jsq-bvj.xls
    Ben Van Johnson

  3. #3
    Forum Moderator Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,881
    Hi JonathanSQ,

    Please take a moment to read the forum rules (link in my signature and at the top of each sub-forum), then edit your thread's title to something more descriptive of your problem.

    Second, and probably more important, it would be better for you to try setting something up yourself, then asking questions in the forum one by one. Being volunteers, most of us have time to answer individual questions, but not to sit down and create a product ordering workbook for you.

    Between this forum and the Excel help file you should be able to get your answers.

  4. #4
    Registered User
    Join Date
    08-20-2008
    Location
    Work
    Posts
    4
    Quote Originally Posted by protonLeah View Post
    Here is one possibility:
    Attachment 26789
    Thanks, Ben. But being a Excel newbie, I really am not sure how to use that??
    I'm attaching what I've made and where I need some help... because I'll be
    honest I am not very clear, again, how to use or even what I am looking to
    copy and implement in the document I've made...

    If you look in my document, under the 'Test Trckr' sheet, you'll see my progress thus far.
    You can find the values for each of the general products under the 'Calculator' sheet.
    I figured out how to add up the sum of the 'Total' column, but I want to add across each
    row based on multiplication. EG, product #1 is worth $20 so if I put a '1' there I want to make it
    so $20 appears under 'Total' for that row, and so on... again, let me know if I am not being very clear

    Thanks
    http://jwsquire.com/czn/S&SO%20Trckr.xls (its 21kb too big for the forums)


    Paul, I've edited my title to be a little more descriptive... also, I do not expect anybody to create a product for me!
    If I only get a general reply pointing me towards a function or tool within Excel that would work for me, that'd help.
    Because I don't even know what sort of function (or tool) I really need in order to do what I want, so I am a little
    lost when trying to look through various Excel tutorial websites I've found from these forums. And I cannot find
    anything through Google similar to what I want to do (although this could be my fault from, perhaps, incorrect use of search words/phrases)

    Thanks!
    Last edited by JonathanSQ; 08-20-2008 at 11:21 PM.

  5. #5
    Registered User
    Join Date
    08-20-2008
    Location
    Work
    Posts
    4
    Ah never mind, after spending further time looking through some
    of the Excel topics on these forums I found a answer

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel crashes due to incomplete VBA compilation?
    By RogerN in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-11-2009, 09:26 PM
  2. Need help with a Excel Macro (I am a Newbie)
    By theebookzoo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-13-2008, 08:36 AM
  3. Five small questions about Excel?
    By SnowCom in forum Excel General
    Replies: 2
    Last Post: 08-10-2008, 03:59 PM
  4. shifting online data comes to excel as per formula with very minimum timelag
    By cramatr in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-04-2007, 10:08 PM
  5. several very important questions about excel
    By excel_user in forum Excel General
    Replies: 1
    Last Post: 09-25-2006, 11:22 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1