Sumproduct shoud work for you.

=sumproduct((C2:C100 = "Approved")*B2:B100)

Here is a link for more info...
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
--
HTH...

Jim Thomlinson


"Andy" wrote:

Hi All,
Any shortcuts on doing conditional addition in a column based on another
column e.g
Col_B Col_C
8 Denied
8 Approved
8 Denied
8 Approved
8 Approved
Add the total to bottom of column B only if its "Approved" in Column C.

Thanks
Andy