How to sum values base on date using multi-row formula

Chalsea

Hi there,

I would like to get some help on how to sum values base on date using multi-row formula.

In the attached file, I would like to dynamically create a new column call daily sum base on the individual date. For example, aggregating all 5/2 impression data into one. Can you please help?

Thanks so much in advance!

Chalsea

Sum by Date.xlsx

grossal

Hi @Chalsea,

it sounds that you are looking for a Summarize Tool in combination with the Join:

Result:

Sample Workflow attached. Let me know what you think.

Best

Alex

2020-05-05-How to sum values base on date using multi-row formula.yxmd