Forum Discussion
Dumb_Fork
Oct 30, 2023Copper Contributor
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...
HansVogelaar
Oct 30, 2023MVP
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.
Dumb_Fork
Oct 30, 2023Copper Contributor
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