Thread: sumif in Excel2007 on Vista doesn't work.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
WesZalewski WesZalewski is offline
external usenet poster
  
Posts: 7
Default 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.
Reply With QuoteReply With Quote