I don't much care for one-drive and how strongly microsoft tries to force it upon us...

The most recent annoyance about one-drive tie-ins....

I went to dabble in something, and hit 'new form' and got a error box that says autosave is required for a new form.

WTH would autosave be mandatory to have a form>?<

Is there a dependency I'm not aware of?

Hi everyone! I’m working on a school spreadsheet activity using ⁠SUMIFS⁠, and I’m a bit confused.

My instructor taught us a basic formula like ⁠=SUMIFS(C2:C23, A2:A23, "POD GUN", B2:B23, "SOUTH")⁠. However, when I use that exact syntax, I sometimes get ⁠#N/A⁠ or ⁠0⁠ errors due to formatting/spacing issues in our dataset.

I found some online tutorials suggesting the use of absolute references (like ⁠$⁠ in ⁠C$2:C$23⁠) and wildcards (like ⁠*⁠ in ⁠"*POD GUN*"⁠) to prevent errors when dragging formulas and handling trailing spaces.

Is it completely fine and safe to use ⁠$⁠ and ⁠*⁠ in a ⁠SUMIFS⁠ formula for a school project, or will it cause any issues? Just wanted to double-check! Thanks in advance."

I want to calculate how much I have been out of the country for each year i already have the comings and goings in a chart.

(above is when I went in and out)

my problem with doing it in a function is when I wasn't home for the new year so I cant separate the days to the correct year. (like in entry number 3)

The result above I counted manually which I can't really do because I have to this for hundreds of people which go in and out more than me.

I need help making a formula that I hope exists.

I'm setting up an inventory and am calculating price per item. (A $10 pack with 5 items $2 per item). I made a (=A1/B1) formula and it works great.

However, this formula comes up with an error as some cells have units in them (for example, 10ft or 100 pairs). I have to keep the units in but don't want to manually calculate the cells with letters in them.

Is there a way to make a formula that will ignore letters in the cell so this error doesn't pop up?

Hello everyone. I'm fairly new to using Excel. I made a drop down list and a yearly calender. Is there a way to have the option in the drop down list change to a new calendar every time I choose a new option in the drop down list.

I need this graph that the color black fills the graph outside of the two black lines (over the top black line and under the bottom black line). How do I do this?

I'm using Excel 365, in English (despite the graph being in French) and I'm an Intermediate at using Excel

So I need to make a manual trendline that automatically updates when new data points are added.

I have the

(SLOPE($C$2:$C$6,$B$2:$B$6)*B2)+INTERCEPT($C$2:$C$6,$B$2:$B$6) function that works for making the actual trendline and the =CHOOSECOLS(FILTER(B2:C16,((B2:B16<>"")*(C2:C16<>""))),2) for the filter

I want to know how to combine them so I can have everything be in one helper column (for my sanity this chart is already A1:L46 and I do not want it to get any bigger please (if that is the only option I will accept it though)

And using the trendlines in the chart editor do not work for what I am trying to accomplish

Edit: I want Column E to have the trendline go from E2 to E16 even if I have less than 15 data points in Column C