Microsoft Office Forums - View Single Post - Sum within a single Cell?

Thread: Sum within a single Cell?

View Single Post

Old

01-14-2017, 10:50 AM

jeffreybrown jeffreybrown is offline

jeffreybrown is offline

jeffreybrown uses Windows Vista

Windows Vista jeffreybrown uses Office 2007

jeffreybrown uses Office 2007

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

jeffreybrown has a spectacular aura about

Default

You are most welcome and thanks for the feedback.

If you are going to have about 210 instances of the formula, you should adjust...

ROW($A$1:$A$200) >> to >> ROW($A$1:$A$300)

300 just puts you on the safe side.

Reply With Quote