I'd assume the table is growing. Given that you have a table, you might as well use table references. The #N/A means there aren't any values meeting the criteria. If there should be, which seems to be the case if copying and pasting the same data produces results, then there must be a formatting difference.

Tabel in sharepoint is now counting 3039 rows. I wrote the formula with rows for 3 years (using B:B would be too much). Could I adjust formula to actual amount of rows (B$2:B$3039)? Since the formula grows it will adjust to the growing sharepoint.