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. That is a problem a colleague faced at work. To solve this problem you can use SUMPRODUCT along with double negation. The double…

Read the rest of this post…

By default, the new Microsoft Office 2007 Suite saves files in the new format. e.g. Word files are now stored as .docx, Excel files are stored as .xlsx and so on. The problem with this format is that it cannot be read on any Office installation below 2007. So, if you send this to a friend of yours running Office 2003, he/she will not be able to even open your file! While saving files you need to change the format from the drop-down box and select Word 97-2003 Document when using Word. Excel lists it as 97-2003 Workbook and so…

Read the rest of this post…

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. The first confirmed Vista flaw also remains unpatched. However, a critical Windows VML bug which was being actively exploited. For more details and an explanation of the bug visit the eWeek article. You can get yourself updated via Microsoft Update or Automatic 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. Three of the four Office patches to be released have been stated as “critical” while one or more of the three Windows patches have been given the same level. The last one is a patch for Visual Studio and Windows. As usual I advise you to ensure that you have all your patches installed. You will get them via…

Read the rest of this post…

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. This can only be exploited if a Malicious Word file is opened. The report is currently under investigation by Microsoft. You can’t do anything to prevent it except the obvious. Please DO NOT OPEN any Word file from a person unknown to…

Read the rest of this post…

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.95/mo Essentials and a $39.95/mo Premium program. The Free program should be ideal for small sites/companies. You get 25 accounts of 2GB, 500MB website with 10GB bandwidth. View a comparison » What…

Read the rest of this post…