Offset function with Match funtion

[amit dev thapa]

I wanted to get the information from Data sheet which is in rows ..i have used the sumif function with offset and match in output file

when in output file c4 cell ..when i select .. it is picking up wrong information from data sheet SUMIF(Data!B$2:B17,'Output file'!$C$4,OFFSET(Data!$B$2,,MATCH('Output file'!$B5,Data!$E$1:$AR$1,0),16)) .. this is the function i am using ..

B5 cell data is coming in C10 .. in the output file i have selected Denver in c4 (c5 should be 31179) ,

 

[bosco_yip]

1] Your formula :

=SUMIF(Data!B$2:B17,'Output file'!$C$4,OFFSET(Data!$B$2,,MATCH('Output file'!$B5,Data!$E$1:$AR$1,0),16))

Formula revised as in red portion :

=SUMIF(Data!B$2:B$17,'Output file'!$C$4,OFFSET(Data!$D$2,,MATCH('Output file'!$B5,Data!$E$1:$AR$1,0),16))

2] See attached file

Regards
Bosco

 

[amit dev thapa]

thanks a lot .. it is working