Or a variation on the same theme:
=SUMPRODUCT(--(MOD(A2:A6,1)=0),A2:A6)
--
David Biddulph

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
One way:
=SUMPRODUCT(--(INT(A2:A6)=A2:A6),A2:A6)
--
David Biddulph

"ekkeindoha" wrote in message
...
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