Try this...

=IF(AND(AA7=-0.03,AA7<=0.04),SUM(O6:S6)+SUM(U6:Y6),"")

--
Rick (MVP - Excel)


"j5b9721" wrote in message
...
IN "AA6" I NEED A FORMULA

IF AA7 IS BETWEEN -.03 AND .04
TRUE SUM(O6:S6)+SUM(U6:Y6)
FALSE DO NOTHING