sumif in Excel2007 on Vista doesn't work.
 

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

sumif in Excel2007 on Vista doesn't work.
 

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.

sumif in Excel2007 on Vista doesn't work.
 

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.

sumif in Excel2007 on Vista doesn't work.
 

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
--
Brevity is the soul of wit.


"WesZalewski" wrote:

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.