Just to show you there are usually more than one way to solve a problem...

=SUMPRODUCT(A2:A6*(MOD(A2:A6,1)=0))

--
Rick (MVP - Excel)


"ekkeindoha" wrote in message
...
excellent - thanks

"David Biddulph" wrote:

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