The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Ask
Anybody can ask a question
Answer
Anybody can answer
Vote
The best answers are voted up and moderated by our team

Using Sumif to Complete the Database Sheet

Back to all questions

Using Sumif to Complete the Database Sheet

6 months ago
Vote Up Vote Down
0
Votes
1
Answer

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 Answer

365 Team 6 months ago
Vote Up Vote Down
0
Votes

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

You must to answer this question.