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
 

Hi,
In the Total cell, enter the formula:
(Asumming data is in rows 2 to 50)
=SUMIF( B2:B50 , "Approved" , A2:A50 )
meaning sum a2 to a50 if corresponding cell in col B equals to "Approved"
--
Regards,
Sébastien
<http://www.ondemandanalysis.com


"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