SOLVED

Issue with Sumifs

Brass Contributor

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

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

@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 (Brass Contributor)
Solution

@Dharmendra_Bharwad 

OK, I understand. See the attached version.

1 best response

Accepted Solutions
best response confirmed by Dharmendra_Bharwad (Brass Contributor)
Solution

@Dharmendra_Bharwad 

OK, I understand. See the attached version.

View solution in original post