Forum Discussion
Need help executing large volume of text formulas
This is a combination of needlessly complex formula turned into text by coping and pasting as values but i need all of the formulas to be executed (452 rows to be exact) but it excel won't ac...
Change the formula in the selected cell to
=SUMIF($C$9:$C$649,F175,$D$9:$D$649)
and press Ctrl+Enter. You should see the result.
Then double-click the fill handle (the little square) in the lower right corner of the cell.
they are individual calculations with different end values as seen above the selected cell.
the above values are the results after double clicking the cells and entering
the above values are the results after double clicking the cells and entering
