sumif where cells contain Number & Text
Biff/Don
Thanks guys for the help, Biff, the formula works a treat, although I
don't understand the Substitute action, it's all part of the learning
curve. The restrictions outlined were already identified, so not a
problem.
Thanks again
Regards
Fred
|