Two Named "ranges" don't give sum result

[RichKat]

Hello,
I have two "Named Ranges" in the Name Manager that have the following Formulas:
Horiz10 contains: =IF(Summary!G7<=10,ROUNDUP(Summary!G7*Summary!F7/10,0),0)
Vert10 contains: =IF(Summary!G7<=10,ROUNDUP(Summary!G7*Summary!E7*2/10,0),0)

In Cell M50 I have SUM(Horiz10,Vert10) but the result is 0. Though when I put those formulas in two cells instead of in "Name" and sum the cells I get the correct result.

What Excel rule am I violating? Or how do I make this work?

Thanks a bunch!

Richard

 

[xld]

Try making the cell references absolute

=IF(Summary!$G$7<=10,ROUNDUP(Summary!$G$7*Summary!$F$7/10,0),0)

etc.

 

[RichKat]

Bingo! Thanks, xld, that did it.