Excel formula - stumped!

Hello,

I have a spreadsheet called 'TRADE' as follows:

Column: A B C
Sept 200 1000
Sept 300 2000
Oct 300 2000
Nov 100 3000

and so on...

I want to be able to add all the values of Coloumn C together in another worksheet, if they say Sept in Column A.
Does anyone know a formula which will allow me to do this? really need some help.

Hi there,

Try: =SUMIF(TRADE!A2:A5,"Sept",TRADE!C2:C5)

HTH,

Fermented R