- Dec 1, 2004
Hello Board, I need to know if its possible to take a column of numbers and create a formula where if there is currently a value in the cell, take that number and also add from other columns....i.e. cell M2 has a value of 20 (no formula), but I want to add the value of 13 in cell D2 and I2 has a value of 4 . Is there a way to add a formula to column M that will add the 20+13+4 and give me a total of 37, then I could drag the formula down column M to all the other cells. They all have different values or numbers in them. Thanks in advance.