Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Addition | Excel Worksheet Functions | |||
Addition? | Excel Discussion (Misc queries) | |||
addition | New Users to Excel | |||
Conditional Addition | Excel Programming | |||
row addition | Excel Worksheet Functions |