Adds ok but try to sum() returns 0
 

Hello from Steved

=J82+J81+J80+J79 is ok

=SUM(J82:J79) returns 0 The Cells format is General, I changed it to
number and it still does not work.

Thanks for looking at my issue.

Adds ok but try to sum() returns 0
 

Try entering it as:

=SUM(J79:J82)

--
Laura Cook
Neenah, WI


"Steved" wrote in message
...
Hello from Steved

=J82+J81+J80+J79 is ok

=SUM(J82:J79) returns 0 The Cells format is General, I changed it to
number and it still does not work.

Thanks for looking at my issue.

Adds ok but try to sum() returns 0
 

Hello Laura.

I've entered as =SUM(J79:J82) as well as =SUM(J82:J79) and still returns 0

Steved

"Laura Cook" wrote:

Try entering it as:

=SUM(J79:J82)

--
Laura Cook
Neenah, WI


"Steved" wrote in message
...
Hello from Steved

=J82+J81+J80+J79 is ok

=SUM(J82:J79) returns 0 The Cells format is General, I changed it to
number and it still does not work.

Thanks for looking at my issue.

Adds ok but try to sum() returns 0
 

I reckon it's text SteveD. Try this, it should verify this

=SUM(--J79:J82)

as an array formula, so commit with Ctrl-Shift-Enter, not just Enter

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Steved" wrote in message
...
Hello Laura.

I've entered as =SUM(J79:J82) as well as =SUM(J82:J79) and still returns 0

Steved

"Laura Cook" wrote:

Try entering it as:

=SUM(J79:J82)

--
Laura Cook
Neenah, WI


"Steved" wrote in message
...
Hello from Steved

=J82+J81+J80+J79 is ok

=SUM(J82:J79) returns 0 The Cells format is General, I changed it
to
number and it still does not work.

Thanks for looking at my issue.

Adds ok but try to sum() returns 0
 

Hello Bob from Steved

I did do a =SUM(--J79:J82) but did not use as a array Formula.

I thankyou.


"Bob Phillips" wrote:

I reckon it's text SteveD. Try this, it should verify this

=SUM(--J79:J82)

as an array formula, so commit with Ctrl-Shift-Enter, not just Enter

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Steved" wrote in message
...
Hello Laura.

I've entered as =SUM(J79:J82) as well as =SUM(J82:J79) and still returns 0

Steved

"Laura Cook" wrote:

Try entering it as:

=SUM(J79:J82)

--
Laura Cook
Neenah, WI


"Steved" wrote in message
...
Hello from Steved

=J82+J81+J80+J79 is ok

=SUM(J82:J79) returns 0 The Cells format is General, I changed it
to
number and it still does not work.

Thanks for looking at my issue.

Adds ok but try to sum() returns 0
 

Really? How did you do that?

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Steved" wrote in message
...
Hello Bob from Steved

I did do a =SUM(--J79:J82) but did not use as a array Formula.

I thankyou.


"Bob Phillips" wrote:

I reckon it's text SteveD. Try this, it should verify this

=SUM(--J79:J82)

as an array formula, so commit with Ctrl-Shift-Enter, not just Enter

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Steved" wrote in message
...
Hello Laura.

I've entered as =SUM(J79:J82) as well as =SUM(J82:J79) and still
returns 0

Steved

"Laura Cook" wrote:

Try entering it as:

=SUM(J79:J82)

--
Laura Cook
Neenah, WI


"Steved" wrote in message
...
Hello from Steved

=J82+J81+J80+J79 is ok

=SUM(J82:J79) returns 0 The Cells format is General, I changed
it
to
number and it still does not work.

Thanks for looking at my issue.

Adds ok but try to sum() returns 0
 

I would guess that your cells contain not numbers but text.
=J82+J81+J80+J79 will cope with that, but SUM() won't.

Change the text entries to numbers.
--
David Biddulph

"Steved" wrote in message
...
Hello Laura.

I've entered as =SUM(J79:J82) as well as =SUM(J82:J79) and still returns 0

Steved

"Laura Cook" wrote:

Try entering it as:

=SUM(J79:J82)

--
Laura Cook
Neenah, WI


"Steved" wrote in message
...
Hello from Steved

=J82+J81+J80+J79 is ok

=SUM(J82:J79) returns 0 The Cells format is General, I changed it
to
number and it still does not work.

Thanks for looking at my issue.