The title of the post is a bit of a misnomer because the SUMIF function in Excel does not allow you to have more than condition. Excel 2007 introduced the SUMIFS function which allowed for multiple conditions. However, if you are using any version prior to Excel 2007 or if the persons who will be using your Excel workbook will be using a version prior to Excel 2007, then the SUMIF function will throw up an error.
By default, the new Microsoft Office 2007 Suite saves files in the new format. e.g.
I reported that Microsoft had planned to release Office Fixes today. It did release office fixes, but the zero-day bug in Word still remains unpatched. eWeek reports that four were pulled citing problems with the quality of the updates.
It had to be coming. As part of its monthly patches release, Microsoft will be releasing eight security bulletins with patches for a several Windows and Office vulnerabilities. These include the patches for Microsoft Word which had remained unpatched last month.
In a new Security Advisory, Microsoft has reported a vulnerability in Microsoft Word 2000, Microsoft Word 2002, Microsoft Office Word 2003, Microsoft Word Viewer 2003, Microsoft Word 2004 for Mac, and Microsoft Word 2004 v. X for Mac, as well as Microsoft Works 2004, 2005, and 2006. Using the vulnerability, an attacker can launch a Zero Day attack.
Even before the release of Office 2007, Microsoft has released Office Live Microsoft Office Live services allow you to create a professional online presence without the expense of buying a server, setting up a complicated infrastructure, and hiring technical staff to maintain it. Microsoft Office Live is a hosted service â€“ all you need is a computer and an Internet connection. Besides the free program MS offers a $19.