=SUM(A1:A75) as the calculation in an Excel field is going to put into that field a sum of all of the numbers in the A column from the first row to the seventy-fifth while on the other hand =COUNT(A1:A75) is just gonna give you the number 75, get it? If you highlight rows 1 to 75 in the A column alone in a selection and then click on the "AutoSum" button of the "Formulas" tab of Excel 2016 then the seventy-sixth row in the A column will get the =SUM(A1:A75) programming. Ways to screw this stuff up include something like =SUM(1,75) which just gives 76 as that is 1+75. Whatever.
No comments:
Post a Comment