View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mo Mo is offline
external usenet poster
 
Posts: 69
Default #VALUE when trying to sum numbers

I am trying to add numbers from the same worksheet using the below:
=N55:N69+N81+N83:N97. I keep getting # Value message. It is important to
note that N81 in the above formula is a sum formula =SUM(N71:N80); is that
the reason I can't get them to add? I've tried using the SUM formula for the
above but receive the same result.

help!!!!!!


--
Thank you for your help
MO
Albany, NY