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

Hi! When you provide ranges of different length, that's problematic for Excel. please don't do that. Add ranges that have the same size. Best, Ned

Follow this topic

Last answered:

29 Mar 2020

Posted on:

29 Mar 2020

Using Sumif to Complete the Database Sheet

1 answers ( 0 marked as helpful)

Posted on:

29 Mar 2020