The article describes how to ignore zeros in a formula by using Excel's AVERAGEIF function, which is useful when dealing with incomplete worksheets or formulas that might result in zero values ...

How to Calculate Hours in Excel Excluding Weekends. An Excel spreadsheet can become an indispensable tool for your business when you harness its power for keeping records and doing computations.

If your Excel formula omits adjacent cells, the error may be because you've set your sheet to absolute reference and need to switch it up.