hi there,
I would like to build a report which would basically be a P&L where I display the cost per segment in 1 table.
My segments being a grouping of a list (departments):
my "base" P&L looks like that:
and the report I would like to build should look like that:
The idea would be to fill in the cost lines (Human Resources, Contractors and Services, Legal, Consulting and external, Equipment & Office, Software and Other IT and Other costs / Income) of the report to sum them up if they belong to the segment.
What would be the equivalent of a SUMIF formula in Excel?
Cheers,