round figures

[ekkeindoha]

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

 

[Eduardo]

Hi,
What would you like to achieve, why you don't include 2.5 and 3.4 in your sum

 

[Jacob Skaria]

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

 

[David Biddulph]

One way:
=SUMPRODUCT(--(INT(A2:A6)=A2:A6),A2:A6)

 

[David Biddulph]

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

 

[ekkeindoha]

excellent - thanks

One way:
=SUMPRODUCT(--(INT(A2:A6)=A2:A6),A2:A6)

 

[Rick Rothstein]

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

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