Hi Karen,

You have a couple of easy options
1) Simply change the format of the cell with the sum result in to a number with 0 decimal places.
2) if the numbers are always going to be whole numbers (These will round it up/down), you could nest the sum function into either text or fixed functions.Examples for summing values in cell range A1:A5:
=FIXED(sum(A1:15),0,TRUE)
=TEXT(SUM(A1:A5),"0")

Please confirm that works.

Thanks,
B