Hi Everyone

I am using a SUMIF formula to analyse phone extensions (for example):

=SUMIF(Range,$B2&$C2&D$1,SumRange)

My problem is that valid phone extensions are 7**## or 7****...

When it performs the SUMIF calculation it treats the * and # as a wildcard and includes values from other phone extensions (e.g. 71245) in the sum.

Is there a way to avoid this? I've tried variations using TEXT() and "" and CONCATENATE etc...

I was intially using VLOOKUP formulas but this was becoming too unweildy.

Any ideas??

Cheers
Steve