G Guest Mar 16, 2005 #1 What's the formula for adding different cells from the same column? Ex. a5+a22+a100
G Gord Dibben Mar 16, 2005 #2 Les In an unused cell type =A5+A22+A100 and hit the <ENTER> key. If those cells have numbers, you will get an answer. OR you could use =SUM(A5+A22+a100) which ignores cells that are not numbers. i.e. A5 = 123, A22 = 123, A100 = "les" The SUM function would return 246 =A5+A22+A100 would throw an error. Gord Dibben Excel MVP
Les In an unused cell type =A5+A22+A100 and hit the <ENTER> key. If those cells have numbers, you will get an answer. OR you could use =SUM(A5+A22+a100) which ignores cells that are not numbers. i.e. A5 = 123, A22 = 123, A100 = "les" The SUM function would return 246 =A5+A22+A100 would throw an error. Gord Dibben Excel MVP
D Dave Peterson Mar 16, 2005 #3 =a5+a22+a100 if the cells are not contiguous. or =sum(a5,a22,a100) =sum(a5:a100) if you wanted all those cells summed.
=a5+a22+a100 if the cells are not contiguous. or =sum(a5,a22,a100) =sum(a5:a100) if you wanted all those cells summed.
