With your numbers in A1:A10 try the below; please note that this is an array
formula. Within the cell in edit mode (F2) paste this formula and press
Ctrl+Shift+Enter to apply this formula. If successful in 'Formula Bar' you
can notice the curly braces at both ends like "{=<formula}"

=SUM(IF(INT(A1:A10)=A1:A10,A1:A10))

If this post helps click Yes
---------------
Jacob Skaria


"ekkeindoha" wrote:

If I enter the numbers as follows

1 2 2.5 3.4 6

it should only add up 1,2 and 6 as it are full figures and not .5 and .4
figures

Thanx