IF help to give value if true Shipping info

I want to put dollar value in corrct colum by days earlly or late. H is the dollar value. I is days late or ontime or earlly. I tried several and just cant get it. Please help

Joelinnh,
Since your example is broken up into days late(values in column I is negative (-)) or
days early (values in column I are positive (+)).
Your formula needs to be in this form:
=COUNTIF(cell value, AND(Cell>lower limit, Cell<upper limit))

Formula in cell M4:
=COUNTIF(I4,AND(I4>-60,I4<-90))

hth
FloMM2

Assuming you actually wanted the dollar value, and not just a 1 in the appropriate column, you can avoid the COUNTIF completely and just use IF with AND, as in the attached.