Posted to microsoft.public.excel.misc

Dave F[_2_] Dave F[_2_] is offline

external usenet poster

Posts: 187

count even-numbered values in a range

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.

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
Count Numbered Items	JB	Excel Discussion (Misc queries)	3	January 13th 07 02:39 PM
how do i count cells with values in a certain range ?	Capt. Trevor Bailey	Excel Discussion (Misc queries)	3	October 11th 06 03:48 PM
Count text values in a date range	Janet BN	Excel Discussion (Misc queries)	2	June 19th 06 04:26 AM
Count the how many different values in a range	beechum1	Excel Worksheet Functions	3	February 12th 06 06:45 AM
How to count a range of values in a single cell?	nyc_doc	Excel Worksheet Functions	3	August 3rd 05 12:30 AM

All times are GMT +1. The time now is 10:39 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us