I have a spreadsheet with two worksheets. The one worksheet contants a load
of data and I want the other to get the information and then round the number
to the next highest as soon as it gets to .6 All the other values I would
like it to keep.

The current formula to get the data from the "Totals" worksheet is
=SUMIF(Totals!A:A,B7,Totals!B:B)

I would like it to take the number that it gets and if it is .6 (OF ANY
NUMBER) i want it to round up to the next highest number. If the number is
between 0 and .5 i want it to show that single decimal value.

Hope this makes sense.