Issue with Sumifs

[Dharmendra_Bharwad]

I am facing issue with Sumifs combined with Index and Match function. I want to have total of staff salaries in sheet 1 from sheet 2. In cell B9 of sheet 1, the amount should be 161998 and in cell C9, it should be 475993 (total of staff salaries from Jan-Mar).

Attach is the sheet.

Thanks in advance.

[#2]

@Dharmendra_Bharwad 

How about

=SUMIFS('2'!B10:E10,'2'!B4:E4,C4)

and

=SUMIFS('2'!B10:E10,'2'!B4:E4,">"&C1,'2'!B4:E4,"<="&C4)

[#3]

@Hans Vogelaar 

Thanks, it works. But my issue is there are different line items in sheet 2. And extracting value from totaling will arrive incorrect figures. I have attached the excel sheet for better understandig.

[#4 · Accepted solution]

@Dharmendra_Bharwad 

OK, I understand. See the attached version.