1: Counting cells with fill colors [/B]

Background fill colors help you to summarize your worksheets effectively and enable you to highlight key points in your data. If there are many cells in your worksheet with similar fill colors, you might want to count cells based on them. Although there is no built-in function to achieve this task, you can create a formula for your reference.

STEP 2: Calculating the sum of absolute values

If you wish to calculate sum of numbers ignoring the minus sign, Excel does not have any predefined function that you can use. You can create a complicated nest of formulas and functions, or you can simplify the task by creating a function of your own.

Name: Create your own.jpg Views: 42 Size: 29.1 KB[B]STEP

STEP 3: Displaying weekday names

Although Excel has functions to display weekdays with the help of the Weekdayl] function, it only shows you a numerical equivalent of the day in the week. If you require displaying weekdays as per their weekday names, you can customize Excel to do just that.

STEP 4: Calculating the number of weekdays in a month

Excel has an excellent function called NetworkDaysll which helps you calculate the number of weekdays in a particular period. What if you need to find out the number of Wednesdays that occur in a particular month? Although you can write a complicated and nested formula, you might either get lost halfway through or you may not be able to estimate the accuracy of the result. You can create a function of your own to keep it simple.