View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ellmcg
 
Posts: n/a
Default How do you write an excel formula to sum data in every second cell

To keep it simple, I would use 2 more columns, the first with:
1
0
1
0
1
0
1
0

etc, and the second with: =A1*B1 etc. Then you can just use the sum
function on that column (and put the answer where-ever you want on the sheet).

"Sarah needs to know" wrote:

I have a list of numbers all in one column and I want to be able to type in a
formula that will SUM the numbers in every second cell only, without having
to click on each cell individually. This is how I do it now,
=sum(a1+a3+a5+a7+a9+....etc). Is there a formula that will tell excel to do
this automattically? If so can you tell me how to do it?