| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count and return pair numbers
What is your definition for pair and impair numbers?
"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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count and return pair numbers
sorry
odd numbers = 2 Even numbers = 4 "bj" wrote: What is your definition for pair and impair numbers? "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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count and return pair numbers
Try these formulas...
Odd: =SUMPRODUCT(--(MOD(A1:F1,2)=1)) Even: =SUMPRODUCT(--(MOD(A1:F1,2)=0)) Rick "Sly" wrote in message ... sorry odd numbers = 2 Even numbers = 4 "bj" wrote: What is your definition for pair and impair numbers? "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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count and return pair numbers
Try these formulas...
Odd: =SUMPRODUCT(--(MOD(A1:F1,2)=1)) Even: =SUMPRODUCT(--(MOD(A1:F1,2)=0)) Mike raises a good point about blanks. Here are revisions to the above which will account for the blanks... Odd: =SUMPRODUCT((A1:F1<"")*(MOD(A1:F1,2)=1)) Even: =SUMPRODUCT((A1:F1<"")*(MOD(A1:F1,2)=0)) Rick |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count and return pair numbers
Rick,
Odd: =SUMPRODUCT(--(MOD(A1:F1,2)=1)) You don't need the =1, (--(MOD(A1:F1,2) returns 0 or 1 anyway -- Regards, Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Rick Rothstein (MVP - VB)" wrote in message ... Try these formulas... Odd: =SUMPRODUCT(--(MOD(A1:F1,2)=1)) Even: =SUMPRODUCT(--(MOD(A1:F1,2)=0)) Rick "Sly" wrote in message ... sorry odd numbers = 2 Even numbers = 4 "bj" wrote: What is your definition for pair and impair numbers? "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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count and return pair numbers
Good point! Thanks for noting that.
Rick "Sandy Mann" wrote in message ... Rick, Odd: =SUMPRODUCT(--(MOD(A1:F1,2)=1)) You don't need the =1, (--(MOD(A1:F1,2) returns 0 or 1 anyway -- Regards, Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Rick Rothstein (MVP - VB)" wrote in message ... Try these formulas... Odd: =SUMPRODUCT(--(MOD(A1:F1,2)=1)) Even: =SUMPRODUCT(--(MOD(A1:F1,2)=0)) Rick "Sly" wrote in message ... sorry odd numbers = 2 Even numbers = 4 "bj" wrote: What is your definition for pair and impair numbers? "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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
| Count Intervals of 1 Numeric value in a Row and Return Count down Column | Excel Worksheet Functions | |||
| Count Intervals of 2 Numeric values in same Row and Return Count across Row | Excel Worksheet Functions | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
| in excel, how do I find which value doesn't have a pair? | Excel Discussion (Misc queries) | |||
Hybrid Mode
