Like Microsoft Excel, Google Sheets includes a simple COUNT function that tells you the number of items in the selected range. But what if you want to know the number of items based on some condition ...

Q. I am trying to do some analysis regarding how many clients each of our departments serviced and how many of those clients were billed over a certain amount. I have our department/ client ...