Andy,

Use SUMIF: put in your "total" cell in column B and change ranges
as required as example assumes data in rows 1 to 10.

=SUMIF(C1:C10,"Approved",B1:B10)

HTH

"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