| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
adding odd numbers
Hi,
If your data are in the range A2:A101, in some other cell (e.g., B2) enter the following formula: it will add all the odd numbers in the column. =SUMPRODUCT((A2:A101)*(MOD(A2:A101,2)=1)) To add only even numbers, change the '1' at the end of the formula to '0') Regards, B. R. Ramachandran "mike1448" wrote: How can I add only the odd numbers in a column of numbers? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding numbers in a single cell | Excel Worksheet Functions | |||
| Adding new numbers as I type without duplicates from Sheet1,ColumnA to Sheet2,ColumnA | Excel Worksheet Functions | |||
| Match Last Occurrence of two numbers and Count to Previous Occurence | Excel Worksheet Functions | |||
| Excel Adding duplicated numbers together | Excel Discussion (Misc queries) | |||
| Re What is the formula for adding multiple numbers in a cell | Excel Discussion (Misc queries) | |||
Hybrid Mode
