Is there any way to shorten formula

Posted by AL on December 29, 2001 7:30 AM

I use this formula in my spreadsheet and was wondering if there was any way to shorten it. Thanks for any help.

:=SUM(AH29+AH31+AH33+AH35+AH37+AH39+AH41+AH43+AH45+AH47+AH51+AH53+AH55+AH57+AH59+AH61+AH63+AH65+AH67+AH69+AH71+AH73+AH75+AH77+AH79+AH81+AH95+AH97+AH99+AH103+AH111+AH169+AH175+AH177+AH181+AH183+AH187+AH189+AH191)

Posted by Aladin Akyurek on December 29, 2001 7:53 AM

AL --

=SUMPRODUCT((MOD(ROW(AH29:AH191),2)<>0)*(AH29:AH191))

will give you what you want.

Aladin

==========

Posted by AL on December 29, 2001 9:11 AM

Thank you very much, it works perfect,