sumif in Excel2007 on Vista doesn't work.

W

WesZalewski

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

WesZalewski

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

Dave F

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
 
Top