Excel attempts to guess which cells you want to include in the function by looking for ranges that are adjacent to the selected cell and that contain numeric data.

Question

Quizplus · Accepted Answer

Excel does indeed try to automatically infer the range of cells you want to include in a function based on adjacent cells containing numeric data. However, this inference is not always accurate, so it's always a good idea to double-check that Excel has selected the correct cells for your calculations.

Excel Attempts to Guess Which Cells You Want to Include