: in cell references in formula (Excel 2003)

  • Thread starter Thread starter jerryk
  • Start date Start date
J

jerryk

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
 
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
 
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.
 
Back
Top