Hi there,
I am somewhat confused by the following problem.
I have a source Table that I manually update using XL-Connector with Data from Salesforce. Using data from this table I populate fields in another table on a second tab. I combine data from these two tables in a third table on a third tab. Everything works fine until I Update the Source Table.
After I update the final Table on the third tab cannot calculate Countifs. The original Countifs look like this:
COUNTIFS(Table2[Sales 2.0 Closing?],"ja",Table1[Status],[@[Criteria 1]])
This function works perfectly until I do the Update. The same function does not work afterwards. What makes it even more peculiar is, that it does not work either if I exchange [@[criteria 1]]) to the value of the field ("Never Booked") nor to the position (E8). Either way I get a #VALUE !
If I split the function into two count functions as follows:
COUNTIF(Table2[Sales 2.0 Closing?],"ja")
COUNTIF(Table1[Status],E8)
both work. However, COUNTIF(Table1[Status],[@[Criteria 1]]) gives me the following error message:
"The syntax of this name isnt correct.
Verify that the name:
-Starts with a letter or underscore (_)
-Doesnt include a space or character that isnt allowed.
-Doesnt conflict with an existing name in the workbook."
I am at the end of my excel wits (of which I don`t have much to begin with), so any help is more than just appreciated.
Thanks
I am somewhat confused by the following problem.
I have a source Table that I manually update using XL-Connector with Data from Salesforce. Using data from this table I populate fields in another table on a second tab. I combine data from these two tables in a third table on a third tab. Everything works fine until I Update the Source Table.
After I update the final Table on the third tab cannot calculate Countifs. The original Countifs look like this:
COUNTIFS(Table2[Sales 2.0 Closing?],"ja",Table1[Status],[@[Criteria 1]])
This function works perfectly until I do the Update. The same function does not work afterwards. What makes it even more peculiar is, that it does not work either if I exchange [@[criteria 1]]) to the value of the field ("Never Booked") nor to the position (E8). Either way I get a #VALUE !
If I split the function into two count functions as follows:
COUNTIF(Table2[Sales 2.0 Closing?],"ja")
COUNTIF(Table1[Status],E8)
both work. However, COUNTIF(Table1[Status],[@[Criteria 1]]) gives me the following error message:
"The syntax of this name isnt correct.
Verify that the name:
-Starts with a letter or underscore (_)
-Doesnt include a space or character that isnt allowed.
-Doesnt conflict with an existing name in the workbook."
I am at the end of my excel wits (of which I don`t have much to begin with), so any help is more than just appreciated.
Thanks