How to add up products across a row based on a price list?
Last edited by JonathanSQ; 08-20-2008 at 11:17 PM.
Reason: editing title
Here is one possibility:
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.
Thanks, Ben. But being a Excel newbie, I really am not sure how to use that??
Originally Posted by protonLeah
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
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)
Last edited by JonathanSQ; 08-20-2008 at 11:21 PM.
Ah never mind, after spending further time looking through some
of the Excel topics on these forums I found a answer
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By RogerN in forum Excel Programming / VBA / Macros
Last Post: 06-11-2009, 09:26 PM
By theebookzoo in forum Excel Programming / VBA / Macros
Last Post: 08-13-2008, 08:36 AM
By SnowCom in forum Excel General
Last Post: 08-10-2008, 03:59 PM
By cramatr in forum Excel Programming / VBA / Macros
Last Post: 05-04-2007, 10:08 PM
By excel_user in forum Excel General
Last Post: 09-25-2006, 11:22 AM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1