Wanting to sum a colum of numbers and then roundup to the next dol

[Guest]

I'am wanting to write a formula that would sum a colum of numbers and then
round those numbers up or down to the hole dollar.
A B
1 22.10 45.76
2 22.35 43.10
3

I would want cell A3 to roundup to 45.00 and cell B3 to rounddown to 48.00.

Thanks for any help.

 

[Guest]

In A3 for your example:
=CEILING(SUM(A1:A2),1)
In B3:
=FLOOR(SUM(B1:B2),1)

 

[Guest]

Thanks BoniM! That's what I was looking for.
AL

In A3 for your example:
=CEILING(SUM(A1:A2),1)
In B3:
=FLOOR(SUM(B1:B2),1)

 

[Guest]

You're welcome, happy to help. Thanks for the feedback!