Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
In Need of proper conditional formula
I'm in need of desperate help with this one.
I need to add the total of column B based on the information in column C. Cells C21 to C46 each reference a list which contains several hundred product names. For example: The list has names like wire1, wire2, wire3, v1wire1, v1wire2, v2-u-1wire1,v2-u-1wire2, v2-u-wire3, etc. I would like to only sum those cells in columm B when the cells in column C matches those parts that start with v2-u-. Everyones prompts solution / response to this is greatly appreciated. -- tech1NJ |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
In Need of proper conditional formula
=sumif(c:c,"v2-u-*",b:b)
=sumif(), =countif() both accept wildcards. tech1NJ wrote: I'm in need of desperate help with this one. I need to add the total of column B based on the information in column C. Cells C21 to C46 each reference a list which contains several hundred product names. For example: The list has names like wire1, wire2, wire3, v1wire1, v1wire2, v2-u-1wire1,v2-u-1wire2, v2-u-wire3, etc. I would like to only sum those cells in columm B when the cells in column C matches those parts that start with v2-u-. Everyones prompts solution / response to this is greatly appreciated. -- tech1NJ -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I write the proper Formula for the following? | Excel Worksheet Functions | |||
creating a proper text formula | Excel Discussion (Misc queries) | |||
PROPER Formula Question | Excel Worksheet Functions | |||
I need help desparately with PROPER formula... | Excel Worksheet Functions | |||
How to use Proper formula? | Excel Worksheet Functions |