• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 194
  • Last Modified:

formulas to simplify calculations


I have monthly key-wise(A1,A2,B1,B2) data available to me for different locations as shown in the attached Excel sheet. I want to have a way to consolidate this data into a higher level Key(A,B) by Month, and then to consolidate it further by applying other fixed numbers to the Key values.

In short, I want to be able to have some formulas for the yellow shaded regions.

Please help.

Thanks. Data.xlsx
2 Solutions
Here is one approach. C13 and across and down:


C20 and across and down:

barry houdiniCommented:
For C20 this method would avoid doubling up the SUMPRODUCT


regards, barry
j1981Author Commented:
Superb! Thank you both!!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now