Formula
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 |
Formula
Hi,
=sum(b10:b19,d13:d15,d18:d19) Separate the groups using commas, not the '+' signs. Regards, B. R. Ramachandran "CanineSleepOver" wrote: 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 |
All times are GMT +1. The time now is 10:20 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com