Hi Rick, it works good so far! Thank you!!!!

But now I find that I need to add more to this too,
=IF(AND(AA59=-0.03,AA59<=0.04,Z59=-3%,Z59<=3%),SUM(O58:S58)+SUM(U58:Y58),"")
with the Z59 section.

I need to add to the formula "Z58" & "Z59" to be within a 10% range (5%up &
-5%down) of each other.
But I need "Z59=-3%,Z59<=3%" part to work also. Do you have an idea how to
do this???

Thanks for your time!!!!
Joe


"j5b9721" wrote:

IN "AA6" I NEED A FORMULA

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