Jenny asks:
Is there a quick way of adding every other cell ?, I have a column of about 250 cells, and I have to select them manually using Ctrl. Can you help ?
Ihm replies:
Another option to sum even/odd cells:
=SUM(NPV({0,-2},A1:A250))/2
=SUM(NPV({0,-2},,A1:A250))/2
Use –A1:A250 and array-enter in case of blanks.
If you’re like me, you’re probably saying WTF. Here’s [...]
Read More...
Read the complete post at http://www.dailydoseofexcel.com/archives/2009/09/30/adding-every-other-cell/
Posted
Sep 30 2009, 08:13 PM
by
Daily Dose of Excel