ISODD/ISEVEN functions on range of cells

[ElmerS]

Hi,

I would like to sum all EVEN values in the range A1:A50 and found out that it is very easy task with:

{=SUM(IF(MOD(A1:A50,2)=0,A1:A50))}

I tried to investigate what the: {=ISEVEN(A1:A50)} will return and got an error.

Is there a way to use ISEVEN to accomplish my request ?

Thanks, Mike

P.S.
To all of you who wonder - this is not a High-School Exercise - it is purely my curiosity.

[NBVC]

I think ISEVEN/ISODD does not work on ranges..only one cell reference allowed...

[shg]

ISODD and ISEVEN are not array-compatible.

[ElmerS]

Thank you both,

Elm

[daddylonglegs]

In fact, in Excel 2007 ISEVEN works with arrays (not ranges) so this formula works

=SUMPRODUCT(ISEVEN(A1:A50+0)+0)

although any blank cells would be deemed to be even so you might want to modify to:

=SUMPRODUCT(ISEVEN(A1:A50+0)*(A1:A50<>""))

....there's also an EVEN function which works with array even in Excel 2003 so you can use a construction like EVEN(A1:A50)=A1:A50 to check for evenness too, but I'm not sure it's an improvement on MOD

[DonkeyOte]

dll, for whatever reason I had never come across EVEN before!

would also make the additional point that ISEVEN/ISODD also require ATP activation pre-XL2007.

[shg]

in Excel 2007 ISEVEN works with arrays (not ranges) so this formula works

It does indeed. I don't see it listed among the documented changes. Whatever prompted you to try?

[ElmerS]

Thank you all,

Elm

[daddylonglegs]

Whatever prompted you to try?

I didn't initially. It was pointed out to me by "pgc01" over at MrExcel.....

[pfigueiredo]

This is a great comunity and you Guys are just fantastic!

Thanks a lot for all the insights on this subject!