C
claireanddoug
Hi,
I am trying to use a wildcard function (*) in a sumif function, e
SUMIF(B:B,A1*,C:C) but excel converts the A1* to "A1*" rather that th
content of cell A1.
If for example the content of A1 was "smith" and i want to find the su
of all cells that contain smith in column B, the sumif works if i ente
"smith*" instead of A1* but the problem i have is that i have
multitude of cells in column a where they will correspond to only par
of the cell in colum b and therefore need to use a wildcard with th
cell reference....
Please can somone PLEASE help...
cheer
I am trying to use a wildcard function (*) in a sumif function, e
SUMIF(B:B,A1*,C:C) but excel converts the A1* to "A1*" rather that th
content of cell A1.
If for example the content of A1 was "smith" and i want to find the su
of all cells that contain smith in column B, the sumif works if i ente
"smith*" instead of A1* but the problem i have is that i have
multitude of cells in column a where they will correspond to only par
of the cell in colum b and therefore need to use a wildcard with th
cell reference....
Please can somone PLEASE help...
cheer