Hi there,
I'm Stefano from Italy and i'm a new user in Excel Forum. I wonder if anyone can help me to fix a formula I'm struggling with. In the attachment you will find a table split by quarters and months with some unexpected items I have to count to build a budget statement. Different items (e.g. x, y, z) can be referring to the same Entity (e.g. "a", "aa" and "aaa" are all affecting "Com ops"). what I'm trying to do is to enter a formula that, for each month and quarter, calculates the total amount of different items for a particular entity only.
For now I've just entered a formula (green cells) that uses a "match" and "index" and returns the total for the whole column (e.g. February) but need to improve it with a sort of lookup in order to sum only the relevant items for a particular entity only (e.g. Com ops).
I would be grateful if anyone could help me with this issue,
regards,
Stefano
Bookmarks