MS Excel working with formula all MS Excel formula PDF file

The example we're going to use is going to be finding the total for a series of values and the average for a series of values. So I'm going to go ahead and click on Sell. E four and I've always begun my formulas with an equal sign that lets Excel know that you're going to put a formula in as opposed to text or some numeric values. And then I'm going to go ahead and type the function name that I want to use. In this case, it's the Sum function because I'm totaling, and then I do opening parentheses and now I need to put the cells in that I want a total. In this case, I want a total of B four, C four, and D four, B four, C four, and D four can be abbreviated B 4D four, or the first cell in the range colon, and then the last sale in the range. I'll then close my parentheses and hit Enter and you'll see I get the total for those values. I'll now click and sell F four and there I want to put the average in. So here again I'm going, to begin with, an equal sign and the function name, which in this case is average. I'll then go ahead and open my parentheses and again enter in the same cells I did before. 

Four and you can always do that. However, if you prefer to use the mouse after you type your opening parentheses, you can simply highlight the range of cells that you wish to include in the formula. Then I'll close my parentheses and hit Enter and you'll see I get the average for those values. Excel also has a tool called the Auto Sum tool. I can use that very simply. Now I'm going to go ahead and click and sell B nine. And again you'll see I want the total for January here. And then I'm going to go to the Home tab on my ribbon and I'm going to come over here to Auto. Sum. And when I click on Auto. Sum, you're going to see that it automatically placed that formula into the cell that I had selected and then chose the cells above it to total.

 And here I am in the Average cell and then I'm going to go ahead and click on Home. Instead of clicking Auto. Sum, which would just give me a sum, I'm going to go ahead and click the drop down arrow to the right of that. And you'll see here we can use this tool with the average count, Min and Max. And I want to use it with average. And there's also a more functions option here. I'm going to go ahead and click average and you're going to see that it highlighted the range B four to B nine for me now, earlier, because the data that I was totaling was directly above the function I was entering in the range was entered incorrectly. But here, I don't want B four to B nine. I don't want to include the total again in the average. I want B four to B eight. So leaving that highlighted, I'm just going to go ahead and highlight the range of cells that I want. And you'll see it replaces it and then hit enter and we have the average. 

 I'm going to go ahead here and click on sell E four and that cell contains the total you'll see here. Again, I'll double click on it and show you equals some B four to D four. And we want to auto-fill that function down into the next four cells. So again, I'm going to click on that and you're going to notice that there's a square box in the lower right-hand corner. If I point at that, my cursor will change. Right now, I have this thick plus sign and I can use this to highlight ranges of cells. If I point at that square, you're going to see that the thick plus sign changes into a skinny plus sign. The skinny plus sign will allow me to auto-fill instead of highlighting. So I'm going to go ahead and point at that and drag it down and you'll see that it filled that formula in for the next four cells. And again, we're going to go over here and double click on that sell. And you'll see the formula. The original formula was equal sum B four to D four or equal sum of the three cells to the left of that function. 

 It copied what that formula did. So when I double click on cell E five here, you're going to say it says equal sum, open parentheses exactly what it said before. But instead of B four to D four, it updated the references to B five to D five. It knew that I wanted to sum the three cells to the left of that formula. So again, Excel automatically updated those references for me. And you'll see if I click on Sell E six, it now says equal some B six to D six. And that doesn't just work with the sum function. I'll click here on average and you'll see the formula that was entered in there, and I can now use the auto fill tool to fill that value down. And you'll see again the references updated themselves. And to complete this exercise, I'm going to go ahead and click on sell B nine and just auto fill over and B ten and auto fill over and that's all it is to putting in a simple formula and function inside of Microsoft Excel.

TAG:

counta,tutorial,count,how to,countif,multiply,concatenate,current time,step by step,microsoft excel,microsoftoffice,sum,help,data,excel,sumif,guide,median,office,analyze,average,subtract,functions,excel 365,office 365,excel 2019,excel 2016,excel 2013,excel2007,excel2010,add,max,basic,divide,vlookup,formulas.