sumif in Excel2007 on Vista doesn't work.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

WesZalewski - 06 Nov 2006 20:17 GMT

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

Reply to this Message

Dave F - 06 Nov 2006 20:27 GMT

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

Signature

Brevity is the soul of wit.

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

Reply to this Message

WesZalewski - 06 Nov 2006 20:54 GMT

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.

> XL 2007 is beta software; there may still be bugs. See here for an email
> address to contact the developers directly:
[quoted text clipped - 3 lines]
> > 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.

Reply to this Message

Dave F - 06 Nov 2006 21:21 GMT

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

Signature

Brevity is the soul of wit.

> Thank you, Dave.
>
[quoted text clipped - 8 lines]
> > > 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.

Reply to this Message