decimal and integer numbers

    Hello everyone!
    In case i have a column with decimal and integer(whole)numbers how can see/use/choose/pick either the decimal or the integer numbers...how can i separate them?
    for example how would i be able to make a sum of all the decimal/integer numbers???
    THANK YOU!

    If I understand, you only want to add the numbers that are integers, skipping the ones that are not. One way to do that, assuming the numbers are in cells D1:D28, is to use the vector formula
    =SUM(IF(INT(D1:D28)=D1:D28,D1:D28,0))
    Hold down the control and shift keys when you hit the enter key for the formula. Excel will put {} around the formula indicating it recognizes it as a vector function. If you just want to sum the non integers, change the = to <>.
    Was this what you wanted?

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login