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

SUMIF after spreadsheet has potential error?

SUMIF after spreadsheet has potential error?

Super Learner
0
Votes
2
Answer

After completing the vlookup and sumif parts of the case study it was advised to change the “Net income” cells as the opposite to the sum used. In this case remove the “-“, this can then be used as a check as the column total should equal zero. On the sheet I completed 2016 & 2017 worked ok, but 2018 did not sum to zero. After retracing my steps and getting the same outcome. I downloaded the “SUMIF_after.xlsm” file, and your version contained the same issue? 2018 did not sum to zero, but 2016 & 2017 did? Could this cause potential issues further in the case study? 

2 Answers

365 Team
0
Votes

Hi!
What was the number that you saw, please?
If it is 3.445E07 or something of ths sort, please ignore this as this is an Excel bug. This shows a number which is 0.0000003445. It is negligible and I am not sure why it appears.
Best,
Ned

Super Learner
0
Votes

Thank you, that makes sense.