For example, I used XLOOKUP with my dummy data that ... cell will update with the new count. While my example is a relatively simple use of COUNTIF, you can use the function to check entire worksheets ...