Hurry! $6.99 domains at MyDomain.com

Until June 05, 2008, you can buy a new domain at MyDomain.com for only $6.99.

Until June 05, 2008, you can buy a new domain at MyDomain.com for only $6.99. Use coupon code: 699DOMAIN at the end of checkout. This is valid on purchase of one $6.99 new .COM, .ORG, .NET, .INFO, .BIZ or .US domain registration for 1 year.

Besides this, you can:

Use coupon code: VPS15 for 15% off any VPS hosting plan.

Use coupon code: DOMAINHOST and get 1 new domain at no cost with purchase of any VPS hosting plan.

Remember, domains are available from WebberZone Domains from $7.95 onwards.

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.

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.

Continue reading “Excel Tutorial: SUMIF with Multiple Conditions”

24 Ways To Contribute To WordPress

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

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

WordPress Plugin Competition underway

Mark offered me the opportunity to look after the WordPress Plugin Competition 2.5 and I’ve taken it. I’ll be making weekly posts of the same on Weblog Tools Collections as well as on the WordPress Plugin Competition Blog.

Mark offered me the opportunity to look after the WordPress Plugin Competition 2.5 and I’ve taken it. I’ll be making weekly posts of the same on Weblog Tools Collections as well as on the WordPress Plugin Competition Blog. First post in the series are a few tips for plugin authors seeking an entry into the competition.

WordPress Wednesday: WordPress Plugin Competition

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.

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. The plugin competition will begin on the 10th of May and will last till the 10th of July.