View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Sum will not display

Thanks, but I think you should re-read Bob's post.

You have created "numbers" that are text by enclosing them in quotes "15"

=B3+D3 will work with text numbers but not with other functions like =SUM or
=AVERAGE

And a Happy New Year to yourself.


Gord

On Sat, 30 Dec 2006 13:08:00 -0800, EOCSUP
wrote:

I was using your first example, and it wanted the second. It worked. Thank
you soo much! Happy New Year to you.


Gord Dibben MS Excel MVP