why won't this formula work? =(h6)-(d6:g6)/2
R Rowan Aug 4, 2005 #2 That all depends on what you mean by won't work. Maybe you want: =(H6)-SUM(D6:G6)/2 Regards Rowan