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
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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks