Hi Laurence,

Am Fri, 04 May 2012 13:27:14 +0200 schrieb Laurence Lombard:

I would like to sum values in columns A,C,an E (odd columns). I have
analysis toolpak installed so that the formula =ISODD(1) returns TRUE

try:
=SUM(IF(ISODD(COLUMN(A:E)),A2:E3))
array formula to enter with CTRL+Shift+Enter


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2