Formula Method

Source Data 9 rows × 10 periods · Categories A, B, C
E P1P2P3P4P5 P6P7P8P9P10
2D Summary — MMULT
G35
Select a result cell
Cat P1P2P3P4P5 P6P7P8P9P10
Click any gold result cell to see the exact formula and which source rows contribute. Use the buttons above to switch between 8 different formula approaches — all produce the same result from the same data.