Formula

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

Guest

I'm new to using Excel and I'm trying to add a group of numbers and
individule numbers.... What I've tried was
=sum((B10:b19)+(d13:d15)+(d18+d19)) and waht it tells me is #VALUE!
Help, what am I doing wrong ??
Thanks
 
Hi,


=sum(b10:b19,d13:d15,d18:d19)

Separate the groups using commas, not the '+' signs.

Regards,
B. R. Ramachandran
 

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

Adding Numbers 3
Payment calculation 1
excel vba - cell value sum 3
help on conditional 2
[newbie] financial accounting problem 1
HOW DO I ADD 10
Changing formulas that won't "formulate" 8
copy conditional formulas that reference one cell 2

Back
Top