| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
if/then formula
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!! |
|
#2
|
|||
|
|||
|
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!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
| formula to combine cells using if/then | Excel Worksheet Functions | |||
| Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
| Help with macro formula and variable | Excel Worksheet Functions | |||
| Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
Hybrid Mode
