Hello

Can anyone tell me what formula I need please?

I have 2 tables, both have our sites listed in column A. I want the second
table to count how many non blank cells there are in column B for each site
in table 1.

The tables look somthing like this:

Table 1:

Site 1 Data
Site 2 Data
Site 2 Data
Site 2
Site 3
Site 4 Data
Site 4
Site 4

Table 2:

Site 1
Site 2
Site 3
Site 4