# 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 ·
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 +

Collapse -

### Not aware of a function for that

by In reply to In Excel,

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

Collapse -

### In Excel

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

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?

Collapse -

### Use Sumif

by 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

• 5

#### What are the best Real Estate Marketing Automation Tools?

nehaagarwalceo ·

• 2

#### What is best to use between pardot and cloud for marketing automation

1409devanshu ·

• 6

Nora.Oz ·

• 6

#### Accounting software

beverleycosgrove59 ·

• 1

#### Software for generating invoices

Michael_Schumacher ·