Did you like how we did? Rate your experience!

Rated 4.5 out of 5 stars by our customers 561

Award-winning PDF software

review-platform review-platform review-platform review-platform review-platform

Video instructions and help with filling out and completing Fill Form 2220 Ii

Instructions and Help about Fill Form 2220 Ii

Sarnax Alfred Mr. Excel podcast, Episode 21, 99 Problems with Two AutoSum. Hey! Welcome back to the Mr. Excel NetCast. I'm Bill Gellin. A couple of weeks ago, I was down in Atlanta, Georgia for the Gulf South Council meeting of the IMA. A lot of great questions came up in that one, including this one that stumped me. Someone said that they had two columns of a lot of AutoSum. So these two cells here, press the AutoSum button. And as they were working, they would insert rows, insert rows, insert rows, and then suddenly column two would quit working. Now, that was bizarre. Like, why would that ever happen? But then, you know, as I was talking through it, you know, I started to replicate what was going on. So we come here, we do Alt + IR to insert a row, type the next item, and 100. That's 800, change this to 900. That's perfect. 200, 1600 changes to 1800. That's perfect. Alright, but then insert another row, and this one has a value. Beautiful. The thousand changes, but column two for whatever reason has no value at all. And then we insert a new row. Alright, see, and that's where the problem comes in. Now, column one is going to work. I want to enter 123 and the number changes. But over here, because I didn't type anything for "jicama" in C11, when I type the value here - 2 - BAM, it's not working right. So what we're running into there is Excel is extending that formula if you have three or more cells that the formula is referring to and you insert a 4th cell, they'll extend it. But they only extend it if you had a number, and well, we didn't add a number...