Hi,



I'm using the following formula: {=SUM(IF(FREQUENCY(IF(Data!C$2:C$10000&rekenen2!B$ 2:B$10000&rekenen2!D$2$10000=$F5&$B$2&$B$1,MATCH (Data!B$2:B$10000,Data!B$2:B$10000,0)),ROW(Data!B$ 2:B$10000)-ROW(Data!$B$2)+1),1))}
when I manually update the data in sheet "data" I have no problems. I go to my sharepoint, export the data to excel and with copy and paste I make the update.
When using the dataconnection method by sharepoint and excel (refreshing), the result of my formula becomes #NA .

What could be the issue?

Regards,

Martin