User Profile
Dumb_Fork
Copper Contributor
Joined 2 years ago
User Widgets
Recent Discussions
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 accept it unless i double click individual cell and then enter. Is there any easier way to do it?Re: Need help executing large volume of text formulas
="=SUMIF(C9:C649,F"&ROWS(C$25:C49)&",D9:D649)" i turned the result of this into text for context P.S i just learned a tiny bit of form yt and experimented and is my 1st time needing to turn a long **bleep** list of sales then separate individual members and add their total purchases to turn them into points 1 point per 100 unit
