Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sumif using wildcard
Hi, I am trying to use a wildcard function (*) in a sumif function, eg SUMIF(B:B,A1*,C:C) but excel converts the A1* to "A1*" rather that the content of cell A1. If for example the content of A1 was "smith" and i want to find the sum of all cells that contain smith in column B, the sumif works if i enter "smith*" instead of A1* but the problem i have is that i have a multitude of cells in column a where they will correspond to only part of the cell in colum b and therefore need to use a wildcard with the cell reference.... Please can somone PLEASE help... cheers -- claireanddoug ------------------------------------------------------------------------ claireanddoug's Profile: http://www.excelforum.com/member.php...o&userid=27490 View this thread: http://www.excelforum.com/showthread...hreadid=470038 |
#2
|
|||
|
|||
Hi!
Try this: =SUMIF(B:B,A1&"*",C:C) Biff "claireanddoug" wrote in message news:claireanddoug.1vs3mn_1127423141.7936@excelfor um-nospam.com... Hi, I am trying to use a wildcard function (*) in a sumif function, eg SUMIF(B:B,A1*,C:C) but excel converts the A1* to "A1*" rather that the content of cell A1. If for example the content of A1 was "smith" and i want to find the sum of all cells that contain smith in column B, the sumif works if i enter "smith*" instead of A1* but the problem i have is that i have a multitude of cells in column a where they will correspond to only part of the cell in colum b and therefore need to use a wildcard with the cell reference.... Please can somone PLEASE help... cheers -- claireanddoug ------------------------------------------------------------------------ claireanddoug's Profile: http://www.excelforum.com/member.php...o&userid=27490 View this thread: http://www.excelforum.com/showthread...hreadid=470038 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
SUMIF with Mutiple Ranges & Criteria | Excel Discussion (Misc queries) | |||
SUMIF, wildcard and cell ref | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |