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
Bookmarks