Average if not blank - Learn Excel #exceltips #exceltutorial #exceltricks #learnexcel #excelmaster

In Excel, you can calculate the average of values in a range while ignoring blank cells using the AVERAGEIF function. The AVERAGEIF function allows you to specify a condition, and it will only average the cells that meet that condition.
=AVERAGEIF (range, "", [average_range])
range: The range of cells to evaluate for the condition.

"": The condition, which means "not blank."

[average_range]: (Optional) The range of cells to average. If omitted, Excel uses the range for both the condition and the averaging.

Example 1: Averaging a Single Range
If you have a range of values in A1:A10 and you want to average only the non-blank cells, use:

=AVERAGEIF (A1:A10, "")
This formula will ignore blank cells in A1:A10 and calculate the average of the remaining values.

Example 2: Averaging a Different Range Based on a Condition
If you have two ranges, where one range (B1:B10) contains the values to average and another range (A1:A10) contains the condition (e.g., non-blank cells), use:

=AVERAGEIF(A1:A10, "", B1:B10)
This formula will check for non-blank cells in A1:A10 and average the corresponding cells in B1:B10.

Alternative: Using AVERAGE with IF (for more complex conditions)
If you need more complex conditions, you can use an array formula with AVERAGE and IF. For example:

=AVERAGE(IF(A1:A10"", B1:B10))
After typing the formula, press Ctrl + Shift + Enter (for older versions of Excel) to make it an array formula. Excel will automatically add curly braces {} around the formula.