View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff
 
Posts: n/a
Default Using sum with cells containing text

How do you get #NUM! from that formula?

Biff

"Max" wrote in message
...
"Blue_Cup" wrote:
Thanks for the replies!
I've inserted that function and keep getting a #NUM! error.


No prob, but I got it to work here based on your sample data
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---