🛠️ 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.
Anybody can ask a question
Anybody can answer
The best answers are voted up and moderated by our team

using sumif to complete database sheet

using sumif to complete database sheet


in the video on the above title, how was net income created?

1 Answer

365 Team

We start with the assumption that the ERP extraction (the source data) we have is correct. Within the extraction the ERP system has calculated Net income for each year. Our goal is to rearrange the items and build a P&L with the categories we have chosen.
By construction a P&L can be defined as Revenues – Costs = Net income;
All items in the P&L (besides Net income) are either Revenues or Costs, then
Revenues – Costs – Net Income has to be 0.
This is why we need to ensure that each sheet’s sum is 0 based on how we have organized the data and on the fact that we subtract Net income through the SUMIF function.
Hope this helps!