yeah how do I not make that Formula go down all cells. like I have a sheet where I want to sum just specific cells and not have the formula go down the whole page. I only want the formula in 1 cell.
Use the SUM function for a specific range. Another way is to give a name for your desired range by selecting your range then going to Name Box and giving a name for the selected range. Then you can use the SUM formula or any other formula to call this range using this Name. For example, if you give a name "Sales" to the range C1:C10. To get SUM range you can write the formula =SUM(Sales).
Well why does my function fill my data in a row and not a column? I’m getting so mad because when I press “sort data” it doesn’t sort my selected data….
My excel do very much legging in new laptop when I put mouse point on any cell its selected to another cell mean . like if I selected G5 cell with mouse than its select another cell , i take help of microsoft support team and they share my screen also but they are unable to detect my problem
If "Select obstructing cells" option is not active it means there is no merged cells in projected spilled array and there is another reason for #Spill error.
The #spill error has made the A1:A8 function worthless in most cases I would like to use it. Very frustrating. And of course, videos such as this are worthless.
yeah how do I not make that Formula go down all cells. like I have a sheet where I want to sum just specific cells and not have the formula go down the whole page. I only want the formula in 1 cell.
Use the SUM function for a specific range. Another way is to give a name for your desired range by selecting your range then going to Name Box and giving a name for the selected range. Then you can use the SUM formula or any other formula to call this range using this Name. For example, if you give a name "Sales" to the range C1:C10.
To get SUM range you can write the formula =SUM(Sales).
Well why does my function fill my data in a row and not a column? I’m getting so mad because when I press “sort data” it doesn’t sort my selected data….
My excel do very much legging in new laptop when I put mouse point on any cell its selected to another cell mean . like if I selected G5 cell with mouse than its select another cell , i take help of microsoft support team and they share my screen also but they are unable to detect my problem
Try to Excel online with browser. if that doesn't resolve the issue in this case try to uninstall MS Office desktop app then install again.
that's not the answer i want
"Select obstructing cells" is greyed out in my Excel so I cant select it
If "Select obstructing cells" option is not active it means there is no merged cells in projected spilled array and there is another reason for #Spill error.
How not to automate #spill error? its annoying that i cant do want I wanted to do because of this automatic formula.
I'm having the same problem, when you ask them additional quiestions, they never answer
The #spill error has made the A1:A8 function worthless in most cases I would like to use it. Very frustrating. And of course, videos such as this are worthless.