🛠️ Scheduled Maintenance | We’ll be undergoing scheduled maintenance and upgrades between 00:00 PST Jan 26th until 00:00 PST Jan 28th. There may be brief interruption of services in that period. We apologize for the inconvenience.

×
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

Regarding: Use Sumif to Complete the Database Sheet

Regarding: Use Sumif to Complete the Database Sheet

Super Learner
1
Vote
1
Answer

Hi
I have two questions regarding this lesson:

  1. Is it Ok that I am not fully understanding the P&L calculations and why we put the negative sign on front of the equations of SUMIF and why the values of each column (2016, 2017, 2018) before the filter were not zero then they became zero after the filter of net income? 
  2. Why did we brought the data by SUMIF and not by VLOOKUP as the data in the previous lecture (the previous columns) ?

 
Thank you

1 Answer

365 Team

Hi M.S.M,
Thanks for reaching out!
To answer your questions:

  1. It is ok, of course. But still, it would be better if you have some context regarding these issues.

P&L calculations boil down to assigning P&L categories to smaller groups of items. What we’re doing is subtracting costs from revenues to arrive at net income. We add a minus sign in front of SUMIF to see costs as negative (because we subtract them) and revenue as positive (the accounting software gave us the figures in a reversed way – positive costs and negative revenues, which is confusing). When summed, the values in each column (if we don’t take the net income value in consideration) should give us net income. We also have net income which is already reported by the accounting software. If we add a minus sign in front of it, we would simply have net income (from the some of all other items) – net income = 0.
2. When you sum numbers you should always use SUMIF to protect yourself from mistakes. VLOOKUP might duplicate one of your results (if the code you’re using is found twice in the lookup column). With SUMIF, you’ll be able to avoid this issue.
Hope this helps!
Best,
Ned
 

I understand why we added a minus sign in front of the ‘net income’ (to check the numbers), but why did we leave the minus there? Weren’t we supposed to reverse the changes (after checking)? Also, wouldn’t it be better to just delete the ‘net income’ rows? We can get those numbers anytime we want by summing up the columns and it wouldn’t confuse us.

2 weeks