Sum 2 columns with 2 conditions

[nordmann]

SUMPRODUCT(--(Table[[CAT]:[CAT]]=$C5);--(Month(Table[[DATE]:[DATE]])=G$3);--(Table[[IN]:[IN]]))

place the amount from table column "IN" into a corresponding cell in another sheet.
Can't figure out how to add another column (OUT) in the above formula.
I wish to summarize both column IN and OUT from table based on two conditions.

Greatful for any help

Workbook example:
(see earlier post: http://www.excelforum.com/excel-form...h-problem.html)
Thanks to TMS

Nordmann

[SDCh]

like this:

Please Login or Register  to view this content.

[nordmann]

Thank's David - it works

[SDCh]

You are welcome and thanks for the rep