Comparison Problem with Averages

[Talon52]

I am trying to come up with a spreadsheet that has 1 page of sales from 6/18/07-8/16/07 (43 days), with 3 rows beneath each column: Row 45=Total (=Sum(b2:b44)), Row 46=Average (=Average(b2:b44)), and Row 47=Average + 10% (=Sum(b46+(b46*.1))). The next page has a daily input from 6/16/08-8/15/08 (43 days) with Row 45 being the total of each column, and Row 46 being the Average of each column.
My problem is that I need to come up with a 3rd page that compares the Average from the 2008 page to the Average + 10% on the 2007 page, and if the 2008 Average is greater than or equal to the 2007 Average +10%, then it puts a "YES" in the box, otherwise it puts in a "NO". Plus if the corresponding cell on the 2008 page is blank (i.e. we havent' made it to that day yet) it needs to stay blank.
I had a formula that read:
=IF('2008'!B2=""," ",IF('2008'!B$46 >= '2007'!B$47,"YES", "NO")), and it seemed to work, until I put something happens that changes the amount to make it read wrong. In other words, Telemarketer A was over the amount needed the first 2 days, so the cells said "YES", but I put in a $0 amount in today's cell, which drops them below the amount needed, and all 3 cells said "NO".
I really need some help with this.

Thanks

 

[konew1]

All 3 cells are comparing the average last year with the average this year. You haven't posted the data but it sounds like the telemarketer A over 3 days has not achieved the required average achieved last year.
Do you want to compare the daily result with last year average?