Column formulas

jdsl

New Member
Joined
Dec 2, 2005
Messages
3
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!
 

Some videos you may like

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Watch MrExcel Video

Forum statistics

Threads
1,118,228
Messages
5,571,012
Members
412,353
Latest member
SofiaV
Top