While trying to calculate the the net income for FY16 i used the whole table as range to SUMIF function instead of just column B which gave me inaccurate results
Function i used =-SUMIF(‘1.1 FY2016′!$B$5:$F$61,’2.1 Database’!B4,’1.1 FY2016′!$F:$F)
Correct Function =-SUMIF(‘1.1 FY2016′!$B:$B,’2.1 Database’!B4,’1.1 FY2016′!$F:$F)
I don’t understand why the results are different since the account code is unique and not redundant in any other column in the FY16 table , hence, the sum for it should be the same regardless of the range used for the SUMIF function
When you provide ranges of different length, that’s problematic for Excel.
please don’t do that.
Add ranges that have the same size.