You can count all cells not equal to x or y using a simple COUNTIFS formula. If you only want to count using one condition, then you can also use COUNTIF as an alternative. I’ll explain both in this...
Sum sales by year using SUMIFS
If you are looking to create a breakdown of yearly sales based on a list of transactions you can use the SUMIFS function.