|Using Excel, I have two columns of numbers; the first contains the dollar value and the second contains the dollar value.|
When I populate the cells for L12, L17,L22,and L27 (dollar values) and N12, N17, N22, and N27 (cents values) by linking this data to another spreadsheet, the two formulas below work correctly:
Total Dollar Value:
Total Cents Value:
The problem I now have is that all four groups of cells are not always used as this is a payroll and all four employees might not work in any given pay period. When I do not enter data into a given "L" cell and its corresponding "N", cell, I get "#value" in both the total dollar cell and the total cents cell.