Excel - adding odd numbers in a cell

Question

Hi,

I'm trying to create a function that will only add odd numbers in a single cell, in Excel. Is there a way of doing this without using VBA or using add ins like "Ku-Tools for excel"?

Thanks

Answer 1

Now I see; you want to sum the odd digits in a number

hope this helps

Formula in A2 is

=SUMPRODUCT(MOD(MID(A1,ROW(A1:INDIRECT("A"&LEN(A1))),1),2)*MID(A1,ROW(A1:INDIRECT("A"&LEN(A1))),1))

best wishes

Answer 2

The data is in D1:D10

The sum of odd numbers is found in D13 using a SUMPRODUCT formula

Note ISODD will not work within SUMPRODUCT, so I used the MOD test

best wishes

Answer 3

Sorry i worded my question in-correctly. 

I don't want to create a function, i want to create a formula to add odd digits in a numbers, without using "user-defined functions" and VBA

Eg: if a1 had the number 28975

the odd numbers would sum up to 21. 

What does the cell B1 refer to in your formula? 

Is it possible at all?

Thanks

Jay.

Answer 4

if you want to create a function, then it has to be coded in some way.   Generally that is in VBA. 

You can possibly achieve the functionality you want just by combining built in functions.  But that would be a "complex" function in a cell.   Generally you couldn't use built in functions to define a generalized new function.

=IF(ISODD(A1),A1+B1,0)

--

Regards,

Tom Ogilvy