The cell has been formatted to be in date format. You just need to format the cell to show numbers. If a number is formatted as a date, it will show an actual date.
sum average max min count numbers
You use the sum button in excel when you want to add numerous amounts of numbers.
Sum Function
=sum(first cell:last cell)
The Sum function or the AutoSum tool.
=SUM(X1:X10)
You can use the formula for the sum of an arithmetic series to calculate that quickly. (Of course, you can also type the numbers into Excel, and get the sum - but that doesn't scale well - e.g., it won't work well if you are then asked, for instance, to get the sum of the first million even numbers.)
Quick-sum in Excel 1. Select the cells you want to sum (Hold CTRL key to select non-adjacent cells) 2. Right click the status bar and select SUM (This is the default option) 3. Now check out the sum of the numbers you selected in the status bar.
Since you put this question in the Excel category, I will answer relative to what you can do with Excel. The quick way is to highlight the column of numbers and click on the Auto-Sum button.
The SUM function. You could also do it with the SUBTOTAL function, but the SUM function is the best one to use.
SUMIFS was new in Excel 2007.
The total of the numbers in D8 + D9 so if say 5 and 2 then the box that had Sum(D8D9) in would read 7 Need to know the two numbers The formula is typed as =SUM(D8:D9)