Posted to microsoft.public.excel.misc

Claus Busch Claus Busch is offline

external usenet poster

Posts: 3,872

ISODD array formula

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
isodd formula does nt work. Any support on that.	Vailore Anandan	New Users to Excel	3	December 15th 08 09:19 PM
conditional formating with isodd and iseven	BIG D	Excel Worksheet Functions	14	November 21st 07 05:10 PM
ISODD and EVEN formula	BSantos	Excel Worksheet Functions	6	January 18th 06 04:28 PM
IF and ISODD Formula Help	vgolfman	Excel Worksheet Functions	2	October 28th 04 03:07 PM
=ISODD Behaving Oddly	Craig[_15_]	Excel Programming	5	April 30th 04 08:59 PM

All times are GMT +1. The time now is 10:30 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us