Sum of Every Other cell

  • Thread starter Thread starter That's Confidential
  • Start date Start date
T

That's Confidential

If I want to work out the sum of every other cell in a column, say for
example, A1+A3+A5+A7 etc......., how would I go about doing it? Is there a
quicker way than actually just using the + sign?
 
=SUMPRODUCT(--(MOD(ROW($A$1:$A$100)-CELL("Row",$A$1)+0,2)=0),$A$1:$A$100)
 
Try this

=SUMPRODUCT((A1:A10)*(MOD(ROW(A1:A10),2)=1))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy/Fill increments 8
Excel formula, sum the value cell and if empty cell left blank 0
question about SUM - how to sum each for elements 5
Skipping cells for SUMIF or COUNTIF functions?? 9
Creating a formula relating to several cells 2
sum of text positions 10
How do you write an excel formula to sum data in every second cell 5
formula to make the value in a cell, to a row in a sum function 5

Back
Top