Need help. I think this would easy for someone well-verse in spreadsheets. I am having trouble getting the total sum of values that have multiple criteria in different ranges. I have two criteria, tha name which is located in one column, and the second one is the date, that is located in one row. The data is in a grid style, and I need to get the total sum of values based on these two criteria, the names are fixed, its just the date that needed to be changed, and ideally the table will update by itself. I created a dummy spreadsheet, and put the desired results below. Thank you.
https://docs.google.com/spreadsheets/d/1TsmngotW5UmFQuNQqC6uGyvRWSYjohPyM36sFlzgmfc/edit?gid=0#gid=0
As I understand you want sum of values according to dates if dates are changed then values should be changed automatically. I have answer for this
=SUMPRODUCT(($B$2:$AF$2>=$B$24)*($B$2:$AF$2<=$B$25)*B3:AF3)
Use this formula in your sheet First select the rows where your dates are present and match it with starting date or end date which is written in your sheet on B24 or B25. when you do change in date at B24 or B25 it will automatically update the values in total value cell.