why not just use the round to start with?

--
Don Guillett
SalesAid Software

"anna" wrote in message
...
Can you please tell how to sum one column of data and at the same time
round
up or down I tried to use if function If (sum B2:B25) integer, round
(sumB2:B25, 0),sum((B2:B25) but it does not work excel does not recognize
the
text in that case