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
