Issue with Sumifs


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.

3 Replies


How about




@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.

best response confirmed by Dharmendra_Bharwad (Contributor)


OK, I understand. See the attached version.