Latest from the blog

Excel Neat Trick – Selecting All The Data In A Table

October 27, 2013 Billy Aung Myint Comments Off on Excel Neat Trick – Selecting All The Data In A Table

Perhaps you might know this already , or perhaps not. I don’t care

Lets say you have a table ,

billy
10

mary
22

john
36

cleo
54

alice
82

james
16

gary
17

And you want to select them , you could just use …

Microsoft Excel Formulas – COUNTIF

October 27, 2013 Billy Aung Myint Comments Off on Microsoft Excel Formulas – COUNTIF

COUNTIF is basically a formula to count how many occurrence of a particular criteria that has been given. Its syntax is as follows

=COUNTIF(RANGE , CRITERIA)

An example , lets say we …