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. 




 

 

 

   

Copyright 2007, Cornerstone Business Solutions, LLC. All rights reserved.

Return to Top