Conditional Addition
 

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

Conditional Addition
 

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

Conditional Addition
 

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