DataMonkette
New Member
- Joined
- Jul 3, 2008
- Messages
- 20
Here's my deal:
I inherited a workbook from a project that my boss worked on at her former company. She'd like to take that exact same workbook and use it for her new project because the same client liked the way it looked. Because the workbook is locked, I've been copying over every single formula by hand (can't even copy/paste from the formula bar), but not really understanding what they do because I'm not really an Excel data monkey. At least not this kind.
Anyway, I've learned much about how everything works in the workbook and every single formula has been copied over faithfully and works in the new book... except for one.
We have one data range (status) that contains information on where in the sales process a given unit is. We have another data range that contains the current selling price for the unit (asking_price). The formula in the cell in question is this:
=SUMIF(status,"",asking_price)
On the old, locked workbook, there's a value. On my brand, spanking new workbook, I am getting a result of 0.
What does the "" part mean? If I could just find out what the "" part means, then I could perhaps find out why I'm getting a 0 because we're so early in the sales process for the new project that not all the variables are the same.
I inherited a workbook from a project that my boss worked on at her former company. She'd like to take that exact same workbook and use it for her new project because the same client liked the way it looked. Because the workbook is locked, I've been copying over every single formula by hand (can't even copy/paste from the formula bar), but not really understanding what they do because I'm not really an Excel data monkey. At least not this kind.
Anyway, I've learned much about how everything works in the workbook and every single formula has been copied over faithfully and works in the new book... except for one.
We have one data range (status) that contains information on where in the sales process a given unit is. We have another data range that contains the current selling price for the unit (asking_price). The formula in the cell in question is this:
=SUMIF(status,"",asking_price)
On the old, locked workbook, there's a value. On my brand, spanking new workbook, I am getting a result of 0.
What does the "" part mean? If I could just find out what the "" part means, then I could perhaps find out why I'm getting a 0 because we're so early in the sales process for the new project that not all the variables are the same.