How do you add the value of a range that contains formulas?
Posted by Lynne on September 24, 2001 11:11 AM
I'm trying to get a column of cells to add and each cell in the column contains a formula. So I want the add function to only recognize the value in each cell instead of the formula. Now I can get it to work if I list each cell in the formula like this: =value(b2+b4)
but since there are 50 cells I need to add I want to put in the range. However, when I do this =value(b2:b52) I get this error:#value!
Can anyone help me? Please??!