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.
Using the COUNTBLANK Function in Building Financial Statements
