Thread: Data connection problem excel/sharepoint using an SUMIF array
View Single Post
 
Old 10-03-2017, 03:26 PM
mwestra74 mwestra74 is offline Windows 7 64bit Office 2013
Novice
  
Join Date: Oct 2017
Posts: 7
mwestra74 is on a distinguished road
Default Data connection problem excel/sharepoint using an SUMIF array
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
Reply With Quote