Adding in a Column

[Medical Officer]

I'm unable to add more than 10 items in a column w/o returning a zero amount.
This is my formula:
=SUM(E6,E13,E20,E27,E34,E41,E48,E55,E62,E69)
I get a $500.20 result!
If I add ,E76 to the above formual I get a zero result!
Thanks for the help!

 

[Mark W.]

What does E76 contain?

 

[Medical Officer]

On 2002-10-16 15:17, Mark W. wrote:
What does E76 contain?

Each of the E's in the formula is a monthly subtotal in Dollars. E76 presently has $0.00 in it.

 

[Aladin Akyurek]

On 2002-10-16 15:15, Medical Officer wrote:
I'm unable to add more than 10 items in a column w/o returning a zero amount.
This is my formula:
=SUM(E6,E13,E20,E27,E34,E41,E48,E55,E62,E69)
I get a $500.20 result!
If I add ,E76 to the above formual I get a zero result!
Thanks for the help!

With E76 housing a value like 0.00, the expanded SUM formula wouldn't result in 0. Apart from that mystery, it seems you're summing/adding up every 7th row value in column E. You could also use the following formula for that purpose...

=SUMPRODUCT((MOD(ROW(E6:E76)-CELL("Col",E6:E76)+0,7)=0)*(E6:E76))

 

[Mark W.]

On 2002-10-16 15:57, Medical Officer wrote:

On 2002-10-16 15:17, Mark W. wrote:
What does E76 contain?

Each of the E's in the formula is a monthly subtotal in Dollars. E76 presently has $0.00 in it.

Okay, E76 is displaying $0.00, but what value or formula do you see in the formula bar when you select E76? Is there a custom number format applied to E76? If so, what is it?
This message was edited by Mark W. on 2002-10-17 15:54