#VALUE when trying to sum numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!!!!!
 
You probably want:

=SUM(N55:N69)+N81+SUM(N83:N97)

_______________________________________________________________________
 
Since you have multicell ranges you need to sue the sum formula wit commas to
delimit the different ranges.

=SUM(N55:N69, N81, N83:N97)
 
Jim,
You are the best. I've been pulling my hair out for nearly two days on
this. Thank you so much for your help!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

OR function 7
Excel How to add numbers in same cell? 2
Add sum formula automatically using VBA 3
Sum Function 9
Sum Function When Formula Produces #N/A 2
Conditional Formatting with VBA 4
Formula appearing as Value in Formula Bar 1
Substituting CRLF with "+" - Transforming a cell containing numbersin a sum of its numbers 2

Back
Top