View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default count and return pair numbers

Try this:

For Even numbers:
=SUMPRODUCT(--(MOD(A1:F1,2)=0))

For Odd numbers:
=SUMPRODUCT(--(MOD(A1:F1,2)=1))


"Sly" wrote:

What function can I use to return the number of pair or impair numbers in a
row

A B C D E F

Row 1 2 6 9 11 16 20 Pair number = 4
Impair number = 2

Thanks

Sly