View Single Post
  #22   Report Post  
Posted to microsoft.public.excel.newusers
Sandy Mann Sandy Mann is offline
external usenet poster
 
Posts: 2,345
Default 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.

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"MartinW" wrote in message
...
OK, Thanks again Sandy.