Creating Multiple Addition of rows in multiple columns and placing in diff column

Hello Everyone,

I am trying to add multiple rows from multiple columns I need to place each total in a different column.

I need to add column $ 4 w/e 01/25/20 to column $ 4 w/e 02/22/20 then in another column I need the sum for columns $ 4 w/e 02/22/20 and $ 4 w/e 03/21/20, so on and so forth.

I am getting a parse error and I also need to figure out how to create the new columns.

Thank you!!

Multiple Adding Formulas Totals to New Column.xlsx

Adding Formula.png

Workflow

Accepted answers

All comments

AngelosPachis

Hi @Fescobar ,

The parsing error is because you are trying to add two different expressions inside a single formula. The formula tool allows you to edit a pre-existing column or create a new one in a single expression box, but it does not allow you to create more.

Also, I see you want to add two columns together, and then keep adding those columns in pairs of two. Do you think that doing that in different columns is the best way forward? I mean you would have to manually create an column for each aggregation and surely doing that in columns is not the best way.

What are you trying to achieve? Maybe we can find a more dynamic way of doing things

Cheers,

Angelos

Fescobar

Thank you .@AngelosPachis the reply and input is greatly appreciated.

So the requirements changed, I need to sum the latest two 4 week columns, then the latest 8 week, so on...

In order words, I don't need to keep adding multiple columns of each week. Does this make more sense?

Thanks again!!

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167