Someone put the following formula into a spreadsheet that I have to maintain:
=ABC!H14:ABC!H18+ABC!H24
I understand the use of : to pass a ranged to a function, but this does not
make sense to me. It only adds the values from H14, H18, and H24. Is the
use of the : here a typo that happens to work, or is there a good useful
purpose for it?

Thank you.
JerryK

It doesn't seem like that should be working. I get a #VALUE! when I use it.
If it was intended to sum the range plus H24, then:

=SUM(ABC!H14:H18)+ABC!H24

If only those three cells were supposed to be added, then:
=SUM(ABC!H14,ABC!H18,ABC!H24)
or
=ABC!H14+ABC!H18+ABC!H24

HTH,
Paul

--

"jerryk" <(E-Mail Removed)> wrote in message
newsFA1E35A-DF62-4A67-9F43-(E-Mail Removed)...
> Someone put the following formula into a spreadsheet that I have to
> maintain:
> =ABC!H14:ABC!H18+ABC!H24
> I understand the use of : to pass a ranged to a function, but this does
> not
> make sense to me. It only adds the values from H14, H18, and H24. Is the
> use of the : here a typo that happens to work, or is there a good useful
> purpose for it?
>
> Thank you.
> JerryK

It sums the values from sheet ABC H14:H18(5 cells) + H24

6 cells in all.

Easier written as =ABC!H14:H18 + ABC!A8


Gord Dibben MS Excel MVP

On Wed, 27 Feb 2008 14:23:41 -0800, jerryk <(E-Mail Removed)>
wrote:

>Someone put the following formula into a spreadsheet that I have to maintain:
>=ABC!H14:ABC!H18+ABC!H24
>I understand the use of : to pass a ranged to a function, but this does not
>make sense to me. It only adds the values from H14, H18, and H24. Is the
>use of the : here a typo that happens to work, or is there a good useful
>purpose for it?
>
>Thank you.
>JerryK

Forgot the SUM function

=SUM(ABC!H14:H18) + ABC!A8


Gord

On Wed, 27 Feb 2008 15:09:04 -0800, Gord Dibben <gorddibbATshawDOTca> wrote:

>It sums the values from sheet ABC H14:H18(5 cells) + H24
>
>6 cells in all.
>
>Easier written as =ABC!H14:H18 + ABC!A8
>
>
>Gord Dibben MS Excel MVP
>
>On Wed, 27 Feb 2008 14:23:41 -0800, jerryk <(E-Mail Removed)>
>wrote:
>
>>Someone put the following formula into a spreadsheet that I have to maintain:
>>=ABC!H14:ABC!H18+ABC!H24
>>I understand the use of : to pass a ranged to a function, but this does not
>>make sense to me. It only adds the values from H14, H18, and H24. Is the
>>use of the : here a typo that happens to work, or is there a good useful
>>purpose for it?
>>
>>Thank you.
>>JerryK

If you check your data, you'll see that *only* H14 and H24 are being
totaled.

You need the Sum() function, as others have brought to your attention.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"jerryk" <(E-Mail Removed)> wrote in message
newsFA1E35A-DF62-4A67-9F43-(E-Mail Removed)...
> Someone put the following formula into a spreadsheet that I have to
maintain:
> =ABC!H14:ABC!H18+ABC!H24
> I understand the use of : to pass a ranged to a function, but this does
not
> make sense to me. It only adds the values from H14, H18, and H24. Is the
> use of the : here a typo that happens to work, or is there a good useful
> purpose for it?
>
> Thank you.
> JerryK