Ever since I activated GPRS on my N73, I’ve been hunting for something to make my blogs mobile friends. There are quite a few WordPress plugins that would achieve the job, however, I remained unsatisfied with them. Then I stumbled upon MoFuse.
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.
24 Ways To Contribute To WordPress gives you a few hints on giving back to the WordPress community in umm … 24 ways. A good read to contribute towards an excellent piece of Open Source Software
Mark announced the new WordPress plugin competition. The past plugin competitions have been highly successful which have helped benefit the WordPress community with excellent offerings. I’m sure this years will be the same if not better.
In Office Live Workspace vs Google Docs: Feature-by-Feature Comparison, Sarah Perez gives us an extremely detailed comparison of Office Live and Google Docs, two of the biggest competitors in the fight for the best online office suite.
I never had the need for a screen recording software to date, however, this is one of the best ways to put up some video tutorials. Wink is a good free software, however Camtasia Studio is feature rich paid software, that has been out of my budget until now. As part of a promotion drive for Camtasia Studio 5, TechSmith is offering Camtasia Studio 3 for free.
I came across Vista’s new Hybrid Sleep feature yesterday when I was busy. What is Hybrid sleep? Hybrid sleep is a low-power sleep state that can help protect your open programs and documents while your computer sleeps.