Kbroccardo
New Member
- Joined
- Feb 19, 2004
- Messages
- 11
I'm trying to create a CSE using named ranges but I keep getting errors. I'm either inputing the data incorrectly or it just doesn't work.
Here's a sample of my current formula: =SUM(IF($A$30:$A$206="DBarnes",IF($F$30:$F$206="Forecast",IF($I$30:$I$206>=DATEVALUE("1/1/2004"),IF($I$30:$I$206<=DATEVALUE("1/31/2004"),$H$30:$H$206,0),0),0),0))
I would like to change the cell references to named ranges. As an example I would like the range $a$30:$a$206 to be named primary.
Can this be done and still use the conditions I have already set up?
Thanks!
Karen
Here's a sample of my current formula: =SUM(IF($A$30:$A$206="DBarnes",IF($F$30:$F$206="Forecast",IF($I$30:$I$206>=DATEVALUE("1/1/2004"),IF($I$30:$I$206<=DATEVALUE("1/31/2004"),$H$30:$H$206,0),0),0),0))
I would like to change the cell references to named ranges. As an example I would like the range $a$30:$a$206 to be named primary.
Can this be done and still use the conditions I have already set up?
Thanks!
Karen