Select Page

## Summary sheet in your excel workbook

There is no defined way for keeping data in excel. Excel users maintain data as desired or as they feel easier to handle. Some users keep data in one worksheet for a week while others for a month. Generally all these weekly or monthly data sheets have common formats...

## To count Odd or Even numbers from a list

If we have to count only odd or even numbers from a data list in excel, we have a number of options available as discussed here: If possible add an extra column just beside the data list you want to count. Suppose data is in column “C” and you have entered a new...

## Sum of Digits of a Number

Have you heard about numerologists? Numerologists study influence of numbers in your life. One such number is sum of digits of your date of birth. Today we will see how we can add digits of a number. The trick is to break the number in individual digits and add them....

## Analysis of top ‘n’ values of data in Excel

ABC Analysis states that 20% rows in any data normally contain the 80% of value. In simple words, in any given data; say Accounts Receivables, top 80% of the receivables are normally found to be due from 20% of all customers! In this situation its handy to know those...

## Sum of Every nth cell in Row or Column

Goal   Excel worksheet have number of rows and columns. Intersection of row and column is known as a “cell”. We insert data in these cells only. Every cell has got a row number and a column number. We have to add value of every nth cell in a row or column. In...