Using the COUNTBLANK Function
In generating a financial statement that includes quarterly data that is
created by summing three months together you will want to use the
COUNTBLANK function and not a SUM function. See the screenshot
below for an illustration.

|