Hi all, this is my first request post here, so let me know if I do something wrong and then I can improve...
My problem: I have a spreadsheet with a first column with the dates of the month, and I need to sum in a second column the costs I had for that same date on various marketing platforms.
Those costs are in the same spreadsheet, with different columns each: for each, I have the date and the cost associated with that date.
My issue is that I don't have always the costs, so sometimes it can be that I have just 5 days filled in for the whole month, while on some other column I'll have all the dates.
Here is an example:
As you can see I can't sum just the columns based on the position of the first date, but I need a way to identify the A2 date in columns C, E and G and then sum the associated cost.
I checked around how to do that with SUMIF and MATCH and INDEX, but couldn't find a way to do that.
Thanks a lot!!
Giovanni
My problem: I have a spreadsheet with a first column with the dates of the month, and I need to sum in a second column the costs I had for that same date on various marketing platforms.
Those costs are in the same spreadsheet, with different columns each: for each, I have the date and the cost associated with that date.
My issue is that I don't have always the costs, so sometimes it can be that I have just 5 days filled in for the whole month, while on some other column I'll have all the dates.
Here is an example:
Date | Total Daily Costs | Facebook costs Date | Facebook costs | Google Ads Date | Google Ads Costs | Bing Date | Bing Costs |
01-03-2020 | 01-03-2020 | 235€ | 01-03-2020 | 15€ | 01-03-2020 | 20€ | |
02-03-2020 | 02-03-2020 | 150€ | 02-03-2020 | 35€ | 05-03-2020 | 70€ | |
03-03-2020 | 03-03-2020 | 175€ | 04-03-2020 | 45€ | |||
04-03-2020 | 04-03-2020 | 45€ | 05-03-2020 | 70€ | |||
05-03-2020 | 05-03-2020 | 110€ |
As you can see I can't sum just the columns based on the position of the first date, but I need a way to identify the A2 date in columns C, E and G and then sum the associated cost.
I checked around how to do that with SUMIF and MATCH and INDEX, but couldn't find a way to do that.
Thanks a lot!!
Giovanni