Thread: SUM of areas
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default SUM of areas

=SUMIF(A:A,"AB",B:B)

You van put AB in a cell and reference that cell as well.

--
__________________________________
HTH

Bob

"Natalie" wrote in message
...
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