Posted to microsoft.public.excel.worksheet.functions

Jezzy

external usenet poster

Posts: 5

Countif function for Even and Odd numbers

Hi Hi,

I need help with a formula. I would like to count a column that consists of
even and odd numbers eg. 28, 31, 43, 50, 60. I like to count how many
numbers in that column is odd or even.

I have tried the following but it didn't work

=countif(a1:a10,"1","3","5")

Appreciate some help here.

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
COUNTIF a cell value is between two numbers	LAWNDALE	Excel Worksheet Functions	3	August 15th 08 11:47 PM
countif colored numbers	Mark	Excel Worksheet Functions	2	May 22nd 08 09:12 AM
Embed a countif function in subtotal function?	Stuck at work	Excel Worksheet Functions	1	February 14th 06 03:19 AM
COUNTIF for range of numbers	bimseun	Excel Discussion (Misc queries)	3	January 24th 06 02:40 PM
Countif for numbers between x and y	don	Excel Worksheet Functions	4	May 5th 05 01:01 PM

All times are GMT +1. The time now is 04:35 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us