Hi John,

Yes, there is a way to calculate the standard deviation of a range of cells that includes blank cells. You can use the STDEV.S function in Excel, which treats blank cells as zero.

Here are the steps to calculate the standard deviation of a range of cells that includes blank cells:

1. Select the cell where you want to display the standard deviation.
2. Type the formula "=STDEV.S(" and then select the range of cells you want to include in the calculation. For example, if you want to include cells D8 to AD8, you would type "=STDEV.S(D8:AD8)".
3. Press Enter to calculate the standard deviation.

The STDEV.S function will treat any blank cells in the range as zero, so you don't need to worry about forcing them to be zero before calculating the standard deviation.