Forum Discussion
Solved
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.
OK, I understand. See the attached version.
How about
=SUMIFS('2'!B10:E10,'2'!B4:E4,C4)
and
=SUMIFS('2'!B10:E10,'2'!B4:E4,">"&C1,'2'!B4:E4,"<="&C4)
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.
OK, I understand. See the attached version.
