How to show a sum of conditional cells from table A in a separate Table?

Hi guys,

Please have a look at the sample excel file I have attached below.

I want a sum of all 'WIP' and 'FINAL' $ from Table A to appear in Table B.

Any help will be highly appreciated.

Cheers,

In J6 put:

=SUMIF($B$6:$B$17,H6,$F$6:$F$17)

And copy down to J7

Hi jjin

I see you are using Excel 2010. So you might as well take advantage of the SUMIFS, no need for SUMIF unless you need to pass the file onto someone who does not have 2007/2010.

Formula:

Please Login or Register  to view this content.

Kevin

Thank you so much. SUMIF and SUMIFS function solved my problem perfectly. Happy holidays you all.