I would like a formula that enables me to sum sales data in say, column c based on the dates in column b. I have many records based on geographies in column a.
so my data has 3 fields. geography, date and sales value. I want to return a sales value aggregate for each geography based on the start /end dates that I choose. The geographies have do not all have a record for every date, so the solution needs to include a reference to actual dates rather than to fixed cell positions.
so my data has 3 fields. geography, date and sales value. I want to return a sales value aggregate for each geography based on the start /end dates that I choose. The geographies have do not all have a record for every date, so the solution needs to include a reference to actual dates rather than to fixed cell positions.
