# Cost Price Comparison

#### ExcelRoy

##### Well-known Member
Hi Guys,

Is there a way to compare various prices against a master list of prices for different suppliers

ie, the master list shows current price with the current supplier

i then need a formula to calculate a total of the prices from Supplier 2, but not all the prices are to be compared

Current Supplier

Brush 4.00
Bin 6.00
Bucket 12.00
Shovel 15.00

Supplier 2

Brush 3.00
Bin #Value
Bucket 10.00
Shovel 12.00

So all i need is a total of supplier 2, for the brush, bucket and shovel (Also to ignore the #DIV/0! and #VALUE)
with a comparison against the current supplier

The next supplier may be

Brush
Bin
Bucket 11.00
Shovel 16.00

So all i need is the total for the bucket and shovel
with a comparison against the current supplier

Hope this makes sense

Many Thanks

### Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
What ranges do your data occupy?

Hi Andrew,

To keep it as simple as possible we should use A1:A442 for the current supplier cost

We can the use C1:C442 as supplier 1 cost

Then E1:E442 as supplier 2 costs

Hope this is ok

Many thanks

Does this formula work for you?

=IF(ISNUMBER(E1),E1,"")

Replies
3
Views
330
Replies
13
Views
407
Replies
5
Views
159
Replies
4
Views
271
Replies
7
Views
229

1,203,545
Messages
6,056,033
Members
444,840
Latest member
RazzelDazel

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back