Another formulas play which will deliver the list of unique postcodes
and their corresponding sums dynamically

Source data as posted assumed in A2:B2 down,
where col B is presumed to contain real numbers

In C2: =IF(A2="","",IF(COUNTIF(A$2:A2,A2)1,"",ROW()))
Leave C1 empty. This is a criteria col for deriving uniques

In D2:
=IF(ROWS($1:1)COUNT(C:C),"",INDEX(A:A,SMALL(C:C,R OWS($1:1))))

In E2: =IF(D2="","",SUMIF(A:A,D2,B:B))
Select C2:E2, copy down to cover the max expected extent of source data, say
down to E200?. Hide/min col C. Col D will continuously return the list of
unique postcodes dynamically as source data is progressively updated while
col E returns the corresponding sums for the invoice amounts

Wave your success? Click the YES button below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Natalie" wrote:
Hi there, I have a list of invoices with postcodes, and I want to know the
amount per postcode. For example.

Column A Column B
Postcode Invoice amount
AB £600
CH £40
AB £50
CH £30
SO £100
SG £40
SO £200
CH £300

And I want to know the total of each postcode but without using a pivot chart?
Can anyone help? I think I need SUMPRODUCT but I'm not sure.

Thanks

Natalie