@ArviLaanements:
When using sumifs I get all the rows containing the data from F5, B1 and B2. But there are some rows with the same date that must be considered as 1.
i.e.
row 1 19JAN17
row 2 20JAN17
row 3 20JAN17

With sumifs I get 3, but it must be 2


@Debaser
when manually exporting the data out of my sharepoint to excel and than copy, paste it into my calculating file (on tab data) there are no problems.
When using the dataconnection refresh function (importing the same sharepoint columns with the same data type) the formula returns #NA