The VP stared. "How did you do that? Where are the helper columns?"
The team watched over her shoulder. "That’s not going to work," one senior analyst scoffed. "You can't multiply ranges like that. You'll just get a #VALUE error." Ctrl Shift Enter: Mastering Excel Array Formula
Maya didn't flinch. She clicked into a single, empty cell and started typing: =SUM((A2:A500="Product X")*(B2:B500/C2:C500 The VP stared
Then came Maya, a quiet analyst who had spent her weekend down a rabbit hole of Excel forums. Ctrl Shift Enter: Mastering Excel Array Formula