COUNTIF FUNCTION

Countif Function Again, Excel Countif  is a function (not always so well known in Excel that has many uses. Let me give you a couple of examples.. You want to count the number of Nos or Yeses in a list… You want to count the number of items in a list that are...

EXCEL SUMIF FUNCTION

Using Sumif One of the more useful (but lesser known functions in Excel is the SumIF function. This has been available in most versions (unlike the SumIFs function – which I am going to cover in another post). So what does it do? Let me give you a couple of...