#### Medical Officer

##### New Member
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!

### Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
What does E76 contain?

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.

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))

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

Replies
2
Views
594
Replies
7
Views
370
Replies
6
Views
192
Replies
7
Views
340
Replies
4
Views
723

1,221,185
Messages
6,158,410
Members
451,490
Latest member
desktopace

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back