Canadian Mac Forums at ehMac banner
1 - 5 of 5 Posts

·
Premium Member
Joined
·
5,688 Posts
Discussion Starter · #1 ·
I've been using Excel for some time now (Office X) and there is a calculation that I would like to know how to do: I have columns down with item, cost, quantity, etc. How would I get the quantity and cost to total up? In other words, I might have 3 of an item at $16.99 each. How would I go about getting a cell to calculate the total of all 3 items? How about another cell to calculate tax and then total? Any Excel users out there that could help?
 

·
Registered
Joined
·
523 Posts
Hi, this is pretty easy to do once you've been shown. Rather than write a couple of paragraphs describing how to do it, you could send me an example spreadsheet of yours. I'll insert the formulas you need and send it back. You should be able to figure it out from there.

Send me a PM if interested.

Cheers!
 

·
Premium Member
Joined
·
1,380 Posts
This sounds like an array type calculation.
Enter as a formula:
= sum (col1*col2) then hold down the command key and hit enter (far right under numbered keypad) The formula should have { } surrounding the formula
Col1 & col2 will have the cells that you are calculating
Hope this is what you are looking for
<edited for spelling>
PS: col1*col2 indicates multiplying the two columns
 

·
Registered
Joined
·
379 Posts
I don't know if this is what you mean, but here goes.



To get a cost enter in C2 "=(A2*B2)" and then copy and paste it down rows 3-5

To get a tax enter in D2 "=(C2*0.15)" and then copy and paste it down rows 3-5

To get a total enter in E2 "=(C2+D2)" and then copy and paste it down rows 3-5
 

·
Registered
Joined
·
435 Posts
I think he is talking about automatic subtotal...

in SQL it would be like:
'SELECT item, SUM(prices)
FROM itemList
GROUP BY item'

for excel, I think you have to look around in the menues
 
1 - 5 of 5 Posts
Top