MATCH or VLOOKUP or ??

S

SMAX

Thank you everyone. I finally got the formula to work. I had to do a
find/replace where I looked for spaces and then removed them.

Thanks again!!
Guy
 
M

Max

Glad to know you got it to work ..

In case you find it's a hassle to always
... do a find/replace where I looked for spaces
and then removed them.
Click to expand...

try the suggested SUMPRODUCT formula
with the TRIM() added, viz. e.g..

=SUMPRODUCT((TRIM(Calls!$A$2:$A$176)=TRIM(A2))*1,Calls!$B$2:$B$176)
 
Top