ExcelBanter - Can't seem to get the formula right

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Can't seem to get the formula right (https://www.excelbanter.com/excel-discussion-misc-queries/124227-cant-seem-get-formula-right.html)

Britt

Can't seem to get the formula right

Hi, I am trying to do a simple formula like D7:D15 but it keeps returning
#value!. If I do D7+D8+D9... the formula works. Any suggestions?
Thanks

JMB

Can't seem to get the formula right

It looks like you want

=SUM(D7:D15)

"Britt" wrote:

Hi, I am trying to do a simple formula like D7:D15 but it keeps returning
#value!. If I do D7+D8+D9... the formula works. Any suggestions?
Thanks

Britt

Can't seem to get the formula right

Well 3 or 4 questions down in the group, I found the answer. =SUM(...) is
what I needed. Thanks!

"Britt" wrote:

Hi, I am trying to do a simple formula like D7:D15 but it keeps returning
#value!. If I do D7+D8+D9... the formula works. Any suggestions?
Thanks

Britt

Can't seem to get the formula right

Thanks, that is just what I needed.

"JMB" wrote:

It looks like you want

=SUM(D7:D15)

"Britt" wrote:

Hi, I am trying to do a simple formula like D7:D15 but it keeps returning
#value!. If I do D7+D8+D9... the formula works. Any suggestions?
Thanks

All times are GMT +1. The time now is 02:46 AM.