SUM Values Values Stands in Matrix

[atif574]

Dear Genius,

Respected Genius,
I want to sum the values of columns by selecting the name from the row and dates from the columns.


I have attached the file For the better understanding.

Thanking in Advance

[Pete_UK]

You can use this formula in C13:

=SUMIFS(INDEX($B$2:$G$5,MATCH($B$9,$A$2:$A$5,0),0),$B$1:$G$1,">="&$B$10,$B$1:$G$1,"<="&$B$11)

Hope this helps.

Pete