Forum Discussion
Solved
SUM formula using array calculates but doesn't populate into cell
I have a sum formula in excel that I am using to calculate the total $ in column but filtering using an IF statement and a ISNUMBER(SEARCH) to look up a corresponding name as an array a...
Hi Peter,
That shall be array formula, entering it into D29 use Ctrl+Shift+Enter instead of Enter (press Ctrl and Shift, hit Enter, release all 3).
Hi Peter,
That shall be array formula, entering it into D29 use Ctrl+Shift+Enter instead of Enter (press Ctrl and Shift, hit Enter, release all 3).
OMG. Of Course! In my haste I totally forgot to do that.