Adding cells until another cell changes

Samuel Dowdy Jr. · 02/18/20

I am trying create a formula to add 2 cells until 2 other cells have data placed in those cells I want to add them.

Andrée Starå · 02/21/20

Ok.

Try something like this.

=IF(AND(ISBLANK(JANUARY47); ISBLANK(JANUARY48)); SUM(JANUARY45; JANUARY46); SUM(JANUARY47; JANUARY48))

The same version but with the below changes for your and others convenience.

=IF(AND(ISBLANK(JANUARY47), ISBLANK(JANUARY48)), SUM(JANUARY45, JANUARY46), SUM(JANUARY47, JANUARY48))

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Andrée Starå · 02/18/20

Hi Samuel,

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Samuel Dowdy Jr. · 02/18/20

Samuel Dowdy Jr. · 02/18/20

I want it to add the projections; unless actual revenues are entered.

Andrée Starå · 02/21/20

Ok.

Try something like this.

=IF(AND(ISBLANK(JANUARY47); ISBLANK(JANUARY48)); SUM(JANUARY45; JANUARY46); SUM(JANUARY47; JANUARY48))

The same version but with the below changes for your and others convenience.

=IF(AND(ISBLANK(JANUARY47), ISBLANK(JANUARY48)), SUM(JANUARY45, JANUARY46), SUM(JANUARY47, JANUARY48))

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Adding cells until another cell changes

Best Answer

Answers

Help Article Resources

Categories