J jdsl New Member Joined Dec 2, 2005 Messages 3 Dec 2, 2005 #1 I am trying to take everything in column B and add it to the value in cell C18. Is there a way to add each cell in column B to C18 without it automatically adding C19, C20...? I only want B1 through B50 to be added to C18. Thanks!
I am trying to take everything in column B and add it to the value in cell C18. Is there a way to add each cell in column B to C18 without it automatically adding C19, C20...? I only want B1 through B50 to be added to C18. Thanks!
Y yeheya Board Regular Joined May 20, 2004 Messages 162 Dec 2, 2005 #2 =c18+sum(B1:B50) Regards, Yeheya