Software

Ask something
Question Locked

In Excel,

0 helpful
4 replies

by zimonar

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Can you tell me please which function I should use to find the cost price per unit?
Thank you.

4 replies

by locolobo

wouldn't that be "TotalCost" / "Number of Units"? Or am I missing something?

by zimonar

Yes please, Suppose I have:
Products Quantity Unit Price
Paper 12 5
Eraser 3 3
Pencil 6 1
Eraser 2 3
Pencil 5 1
Paper 24 5
Pencil 20 1
Eraser 10 3
Pencil 15 1
Paper 30 5
Paper 25 5
Eraser 3 1
Paper 50 5
Pencil 12 3
Pencil 6 3
Eraser 10 1
Eraser 5 1
Paper 100 5

- which function I should use to find the TotalCost of each of Products such as:
Paper Total?
Pencil Total?
Eraser Total?

- Thanks for your reply!

by locolobo

As an example, assume the values above are in A2:C19

In cells D2:D19 calculate the Total Cost (e.g. D2 contains =C2*b2)

Now you can use the Sumif function to calculate each of your categories.

SUMIF(range,criteria,sum_range)

In this example range = a2:a19
criteria = Paper, Eraser or Pencil
sum_range is the range to be summed.

Using Paper as an example:

=SUMIF(A2:A19,"Paper",D2:D19)

This worked for me in Excel 2003. To do the other categories substitute "Pencil", etc. for the criteria.

This discussion is closed to new replies.