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

[samba_ravi]

Try

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

or

=SUMPRODUCT(($B$2:$G$5)*($A$2:$A$5=$B$9)*($B$1:$G$1>=$B$10)*($B$1:$G$1<=$B$11))