Hey,
I'm pretty new to excel, so maybe this is simple to do, but I need help with:
I have a default table I import the data from my team's activity by date, if we do the same thing on the two days later, I will add the same table a few rows down, just with the new data, my problem is, I need to sum those values by week and the dates we do things are different every week, so I don't have a fixed place where each date will be each week, because if there is no activity, there is no table for that date, so I might have a week with 2 tables and another with 4
So I have the same default table at the top of my spreadsheet but the date cell is the week's range and I need a formula that if the date in a column ( ex: column C) is between this range (the week range), it will sum the cell on the row bellow on the column D and so on, in a way my week table will have the sum values from the tables bellow, but only if the date matches. Here is a silly example of what my table is for visualisation:
I'm pretty new to excel, so maybe this is simple to do, but I need help with:
I have a default table I import the data from my team's activity by date, if we do the same thing on the two days later, I will add the same table a few rows down, just with the new data, my problem is, I need to sum those values by week and the dates we do things are different every week, so I don't have a fixed place where each date will be each week, because if there is no activity, there is no table for that date, so I might have a week with 2 tables and another with 4
So I have the same default table at the top of my spreadsheet but the date cell is the week's range and I need a formula that if the date in a column ( ex: column C) is between this range (the week range), it will sum the cell on the row bellow on the column D and so on, in a way my week table will have the sum values from the tables bellow, but only if the date matches. Here is a silly example of what my table is for visualisation: