In Numbers, I am trying to have a sum that looks like this:
Is this what you want?
Formula in E2 (and Fill Down)
If you choose a from a Pop-Up, E multiplies X and Y.
If the Pop-Up in not equal to a, E will show "" (NULL, the cell will appear blank).
Retrieving data ...