Last answered:

29 Mar 2020

Posted on:

29 Mar 2020

0

Using Sumif to Complete the Database Sheet

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
1 answers ( 0 marked as helpful)
Instructor
Posted on:

29 Mar 2020

0
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

Submit an answer