Hi
Without coloring cells, just based on formulas to calculate the average regarding certain criteria.
You can include empty cells in the selceted range for calculation, it won't affect the result, but I recomend generally to keep ranges as tight as possible.
|