View Single Post
  #23   Report Post  
Posted to microsoft.public.excel.newusers
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
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.



Aren't you supposed to be a "dour" Scot? <vbg


--


Regards,


Peo Sjoblom