What's this mean in Excel? =SUM(F7:F11)/COUNT(C7:C11)?

Answer 1

That formula would return the total sum of all values in the cells from F7 to F11 (provided they all properly had numbers) and divide that by the number of cells which contain numbers in cells C7 through C11.

It is possible that cells in either column 'F' could contain other values, such as text, which would cause the SUM function to return #VALUE!. However, in the case of column 'C' in which COUNT is employed (with only the range as the parameter) it will count those cells containing a number. If three cells contain text and only two with numbers, then COUNT(C7:C11) would return 2. If all cells beetween C7 and C11 contained numbers, then it would return the same number of cells as those used in the SUM function and would be the same as performing an average as another answerer noted.

You will need to be aware of the data in those cells.

Answer 2

SUM - is the term to add things
COUNT- is the term to count the number of cells with numerical values
: - is the through sign; like add cell F7 through F11
/ - division symbol
So "SUM(F7:F11)" means to add F7 through F11
And "COUNT(C7:C11)" how many numerical values are between C7 and C11.
So this would mean divide the sum of F7:11 by the number of numerical values between C7:11

Answer 3

Within the cell that this formula resides, it will add up all the numbers in cells F7,F8,F9,F10, and F11, then divide that number by however many cells in the range C7 through C11 have data in them.

In other words, within first range of F7 through F11 all the numbers will be added. In the second range of C7 through C11, only the number of cells will be counted that have data in them.

Answer 4

Well that is the long way of calculating the average number of the 5 selected cells. The more common formula would be '=avg(F7:F11)'.