Thank you, Dave.

I did what you suggested. Do I just wait for the answer from them?
I am new to this group and never used any blog.

"Dave F" wrote:

XL 2007 is beta software; there may still be bugs. See here for an email
address to contact the developers directly:
http://blogs.msdn.com/excel/contact.aspx
--
Brevity is the soul of wit.


"WesZalewski" wrote:

=IF(MONTH(TODAY())=MONTH($H$3),SUMIF(Jan!$G$16:$G $41,Summary!$B162,Jan!$X$16:$X$41),0)
This formula works fine in 2003. Shows result different than 0. I mean shows
correct results. In 2007 all results of formulas in the whole sheet are 0.