software

Trying to add cell vaules in a very large workbook, but I only need the value
of every other cell. What is the easiest why to do this?

Try something like this:

For numbers in cells A1:A10
B1: =SUMPRODUCT((MOD(ROW(A1:A10),2)=0)*A1:A10)

If you want the quot;otherquot; cells added, instead:
B1: =SUMPRODUCT((MOD(ROW(A1:A10),2)=1)*A1:A10)

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;Michelle Odellquot; wrote:

gt; Trying to add cell vaules in a very large workbook, but I only need the value
gt; of every other cell. What is the easiest why to do this?

Michelle
Might not be the easiest way but if you create another column to the right
of the column you want to sum and enter the following formula in each cell:
=IF(MOD(ROW(),2)=1,,RC[-1])
This divides the row number by 2 and if there is a remainder, it concludes
that the row number is an odd number and gives the answer 0. If the row
number is even it copies the value from the preceding column. Now all you
have to do is Sum the new column to get total for every odd row.

If you want every even row instead, then use
=IF(MOD(ROW(),2)=0,,RC[-1])

Someone may well come up with something simpler but maybe this will do for
the time being
Regards
Philipquot;Michelle Odellquot; lt;Michelle gt; wrote in message
...
gt; Trying to add cell vaules in a very large workbook, but I only need the
gt; value
gt; of every other cell. What is the easiest why to do this?