COUNTIF formula explained

COUNTIF formula explained

Written by: Thomas Szigeti The COUNTIF formula With this handy formula we can count occurances very quickly. This is one of the basic formulas we will use day by day.  It can count occurrences in large data sets for a certain criteria. Have you ever had to tally up...
COUNTIFS formula with multiple criterias in excel

COUNTIFS formula with multiple criterias in excel

How to use the COUNTIFS formula with multiple criterias. In this next example we will build a simple, but posh little tool that you can wow your managers with. This is why you are here right? It will be based on the COUNTIFS formula, which is the big brother of the...