Software

Our forums are currently in maintenance mode and the ability to post is disabled. We will be back up and running as soon as possible. Thanks for your patience!

Question

Locked

In Excel,

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

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Not aware of a function for that

by LocoLobo In reply to In Excel,

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

Collapse -

In Excel

by zimonar In reply to Not aware of a function f ...

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!

Collapse -

Use Sumif

by LocoLobo In reply to In Excel

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.

Related Discussions

Related Forums