Excel Tips, Tricks, and Shortcuts

Hello there. I'm Michael Leng. Today, in my blog "Exceltip2day" , I'm going to talk about: How to count the only number (Excluding text) In Excel , not only calculate the sum amount of figure/number but also result in the number of active cells that having the data(number) in them.  Tip Quiz What is the shortcut to delete cell(s) in Excel Worksheet? The result will give us to know that how many cells which contained the numbers we are using them. This Excel formula will skip counting if those cells are blanked or having another data beside the number(s). Here below is a formula: = COUNT(A first reference cell : An end reference cell ). Pertaining the mentioned formula above will be used for count the amount of cell(s) in column (s)/row (s) within the range declare in a formula. Not capable of counting the alphabet, symbol, empty cell(s) entered into the cells. For example, all the cells in the column from A1 to A8 below being fill...