How to SUM only numbers in a range with Text?
Hi Martin,
Seeing my response in print it looks a bit terse - I must have been
associating with Harlan too much <g
I did not mean to put your formula down, I was just in a bit of a rush
when I wrote it. Your formula does satisfy the OP's requirements as
stated with no double digit numbers given.
My apologies, it was not meant that way.
Aren't you supposed to be a "dour" Scot? <vbg
--
Regards,
Peo Sjoblom
|