SORT RESULTS OF A FORMULA (this should be very simple)

I have a column with results of a formula.

When I try to sort it; insteat of doing it by the RESULT of the calculation;
it's sorting by the formula info that is inside the cell.

The autofilter didn't work eaither, there is any other option. Thank you.!!!

can you give us a sample of your formula in the cell? I just did simple test
with a simple sum formula and it seemed to sort properly.

"HERNAN" wrote:

> I have a column with results of a formula.
>
> When I try to sort it; insteat of doing it by the RESULT of the calculation;
> it's sorting by the formula info that is inside the cell.
>
> The autofilter didn't work eaither, there is any other option. Thank you.!!!
>

The formula is this one
=ROUNDDOWN((H9), 0) and is sorting by the H number
Example:
=ROUNDDOWN((H9), 0)

=ROUNDDOWN((H10), 0)

=ROUNDDOWN((H11), 0)

On the H Column there is another formula that says:

=Calculations!C15
=Calculations!C30
=Calculations!C45


"tim m" wrote:

> can you give us a sample of your formula in the cell? I just did simple test
> with a simple sum formula and it seemed to sort properly.
>
> "HERNAN" wrote:
>
> > I have a column with results of a formula.
> >
> > When I try to sort it; insteat of doing it by the RESULT of the calculation;
> > it's sorting by the formula info that is inside the cell.
> >
> > The autofilter didn't work eaither, there is any other option. Thank you.!!!
> >