Assume that you have a header row (row1). Also assume that you enter
the receipt number in column A for every item bought (so you would not
have a blank next to orange in your example) and that multiple items
on the same receipt are in consecutive rows. Then you can put this
formula in D2:

=IF(A2=A1,"",SUMIF(A$2:A$100,A2,C$2:C$100))

Copy the formula down as required. I've assumed 100 rows of data -
adjust to suit.

Hope this helps.

Pete

On Oct 18, 11:46 am, Mik wrote:
Hello,

I am looking for some assistance.
Please see the following example:-

Col A Col B Col C Col D
1 apple 0.10 0.10
2 pear 0.15 0.30
orange 0.15
3 banana 0.20 0.20
4 kiwi 0.22 0.22

Lets assume that Column A is a receipt number, and Column B is product
purchased, and Column C is the unit cost, and Column D is the total
cost for that particular receipt.

I want to sum the applicable contents of column C, depending on the
value of Column A.

This I find simple, however I have the following problem.

If somebody purchases multiple items, i wish to display the receipt
Number only once for their transaction, and will not be displayed
against each item they purchased.
So, as per the following example, receipt 2 (Column A) contained 2
purchases each costing 0.15 (x2).
So, i want to show the sum of 0.15 + 0.15 in the appropriate row of
Column D

The purchaser could buy any number of items, so how do i sum this
value, when he could buy anything between 1 or 10 items?

Thanks in advance,

Mike