Microsoft

Excel Tutorial: SUMIF with Multiple Conditions

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 negation is simply two minus signs one after an another. The net effect is that it doesn’t change the value of the calculations.

The reason we use the double negation is because, Excel does not always understand that TRUE=1 and FALSE=0 when you use SUM or SUMPRODUCT.

Read More »Excel Tutorial: SUMIF with Multiple Conditions

Microsoft to enter Online Payment market

ZDNet Blogs has a report about Bill Gates’ speech at the Davos World Economic Forum. If you want to charge somebody $0.10 or $1 a month, that will just be a click…you won’t have to manage some funny thing or pay some big credit charge, where half of it goes to the clearing.

Ten Fixes, but Word remains Unpatched!

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.

Microsoft files for RSS Patent!

In a startling revelation, Microsoft had filed for two patents covering technology used to organize and read syndicated Web feeds, such as those delivered via the widely used Really Simple Syndication, or RSS, family of formats reports C|Net. This follows Google’s attempt to patent ads in feeds. Filed on June 21, 2005, the first covers “finding and consuming Web subscriptions in a Web browser.