sumif in Excel2007 on Vista doesn't work.

[Guest]

=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.

 

[Guest]

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

 

[Guest]

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.

 

[Guest]

As I say, maybe it's a bug. XL 2007 is currently in beta (test) mode. If
it's a bug, no doubt they've heard of it.

Dave