Hi JW
MAke sure the new cells are formatted correctly and make sure they contain
numerical data and not text.
HTH
Michael

"JW" wrote:

I have a current spreadsheet with dollars for each employee in their home
dept. this is the current formula I have -
=SUM(IF($A$2:$A$160=B178,$G$2:$G$160,0)). I want to expand the cell range to
163 but when I make this change, it tells me "#VALUE!". Help!!