Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
CONDITIONAL SUMMING
How to sum amounts appearing in column C if the string "Manufacturing" is
appearing in any of the respective cells of Column B? Something like: =SUMPRODUCT(--(SEARCH("Manufacturing",B1:B6,1)0),C1:C6) Column B may contain: Manufacturing-Textile Manufacturing-Spinning Manufacturing-Steel All should be added! All help shall be highly obliged. Thanx! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Summing | Excel Discussion (Misc queries) | |||
Conditional Summing | Excel Worksheet Functions | |||
Conditional summing | Excel Discussion (Misc queries) | |||
"Conditional" summing | Excel Worksheet Functions | |||
conditional Summing | Excel Worksheet Functions |