EXCEL formulas

[Closed]
Report
-
Posts
2805
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 14, 2021
-
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

1 reply

Posts
2805
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 14, 2021
481
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