I have a range of randomly generated, positive whole numbers and need
to count the even values.

I assumed something like =SUM(--(ISEVEN(A1:A100))) entered as an array
formula would work, similar to entering =SUM(--(ISBLANK(A1:A100))) as
an array formula counts the blank cells within the referenced range.

But using ISEVEN in this manner returns #VALUE!

Is there another way to do this?

Thanks.

I seem to have answered this: =SUM(--MOD(A1:A100,2)) entered as an
array gives the correct answer.

Dave

On Aug 1, 10:45 am, Dave F wrote:
I have a range of randomly generated, positive whole numbers and need
to count the even values.

I assumed something like =SUM(--(ISEVEN(A1:A100))) entered as an array
formula would work, similar to entering =SUM(--(ISBLANK(A1:A100))) as
an array formula counts the blank cells within the referenced range.

But using ISEVEN in this manner returns #VALUE!

Is there another way to do this?

Thanks.

=SUMPRODUCT(--(MOD(A1:A100,2)=0)) will work
or
=SUM(--(MOD(A1:A100,2)=0)) as an array formula

Are you sure that =SUM(--(ISBLANK(A1:A100))) works?
--
David Biddulph

"Dave F" wrote in message
ups.com...
I have a range of randomly generated, positive whole numbers and need
to count the even values.

I assumed something like =SUM(--(ISEVEN(A1:A100))) entered as an array
formula would work, similar to entering =SUM(--(ISBLANK(A1:A100))) as
an array formula counts the blank cells within the referenced range.

But using ISEVEN in this manner returns #VALUE!

Is there another way to do this?

Thanks.

Try this array* formula:

=SUM(IF(MOD(A1:A100,2)=0,A1:A100))

* Commit with CTRL-SHIFT-ENTER

Hope this helps.

Pete

On Aug 1, 3:45 pm, Dave F wrote:
I have a range of randomly generated, positive whole numbers and need
to count the even values.

I assumed something like =SUM(--(ISEVEN(A1:A100))) entered as an array
formula would work, similar to entering =SUM(--(ISBLANK(A1:A100))) as
an array formula counts the blank cells within the referenced range.

But using ISEVEN in this manner returns #VALUE!

Is there another way to do this?

Thanks.

Every time I've used =SUM(--(ISBLANK(A1:A100))) it has worked.

I solved this particular problem with: =100-(SUM(--MOD(M2:M101,2)))
entered as an array formula.

On Aug 1, 11:06 am, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
=SUMPRODUCT(--(MOD(A1:A100,2)=0)) will work
or
=SUM(--(MOD(A1:A100,2)=0)) as an array formula

Are you sure that =SUM(--(ISBLANK(A1:A100))) works?
--
David Biddulph

"Dave F" wrote in message

ups.com...



I have a range of randomly generated, positive whole numbers and need
to count the even values.

I assumed something like =SUM(--(ISEVEN(A1:A100))) entered as an array
formula would work, similar to entering =SUM(--(ISBLANK(A1:A100))) as
an array formula counts the blank cells within the referenced range.

But using ISEVEN in this manner returns #VALUE!

Is there another way to do this?

Thanks.- Hide quoted text -

- Show quoted text -

Hard to tell without seeing your data, but =MOD(A1,2) tells whether a number
is evenly divisible. If it returns a 0 it is even.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Dave F" wrote:

I have a range of randomly generated, positive whole numbers and need
to count the even values.

I assumed something like =SUM(--(ISEVEN(A1:A100))) entered as an array
formula would work, similar to entering =SUM(--(ISBLANK(A1:A100))) as
an array formula counts the blank cells within the referenced range.

But using ISEVEN in this manner returns #VALUE!

Is there another way to do this?

Thanks.