Hello Excel community,
After looking at many forums and tutos I didn't find a way to solve my problem so I would need you help
I need to summarize my spendings per month for different campaigns I realized during periods of time. The problem is that some campaigns are overlapping between 2 months, for example, from 28/03 to 04/04 which is a problem because I then have to split the spendings of this specific campaign and allocate it to March and April. (you fill find an example in the screenshot attached).
I thought about doing SUMIFS but I don't know how to write it to make sure that it includes the specific campaigns which were actually in 2 different months.
I hope I am making myself clear
Does someone have an idea of how to solve it ?
Thank you very much in advance for your help !!
Cheers,
apo234
Bookmarks