| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum if based on PARTIAL content of another cell
One way:
=SUMIF(A:A,"*-XYZ-*",B:B) In article .com, wrote: I have a worksheet where the first column contains a special code specific to each product we sell, containing a code for 1) the territory where it's sold; 2) the vendor; 3) the product name; etc. I am trying to figure out a way to create a sumif formula (or other formula if necessary) to only sum, for example, values where the vendor is XYZ. Here's an example: C-SRS-INC-ARBYS-5 50 C-SRS-SLF-TESTY-1 75 C-SRS-INC-CRASHY-3 C-SRS-TMN-TESTY-3 C-SRS-TMN-TESTY-4 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy row based on cell content | New Users to Excel | |||
| how do I change the content of one cell based on another? | Excel Discussion (Misc queries) | |||
| Delete Row based off cell content | Excel Discussion (Misc queries) | |||
| eliminate partial content from the cell | Excel Worksheet Functions | |||
| formula to extract partial content (text) of cell | Excel Discussion (Misc queries) | |||
Hybrid Mode
