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...
OK, I understand. See the attached version.
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.