EXCEL formulasClosed

Question

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.

Thanks

TrowaD · Answer

Hi jamdav666,

Use the following array formula:
=SUM((TRADE!A1:A4=A1)*(TRADE!C1:C4))

An array formula needs to be confirmed by hitting Ctrl+Shift+Enter for it to work correctly. If done correctly the formula will be enclosed by curly brackets {}.

Best regards,
Trowa

EXCEL formulas

1 response

Similar discussions

Subscribe To Our Newsletter!