Thread: Odd and even numbers
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_] Ashish Mathur[_2_] is offline
external usenet poster
  
Posts: 1,766
Default Odd and even numbers
Hi,

Try this array formula (Ctrl+Shift+Enter)

=COUNT(IF((MOD(A1:E1,2)<0),A1:E1))

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

"RodJ" wrote in message
...
I need a function that would count how many are odd/even numbers in a row
or
column.
eg:
1,3,6,22,35 = this row has 3 odd and 2 even numbers. Is there a function
that can count this for me.

Thanks
RodJ

Reply With QuoteReply With Quote