P
patrick
I have code that queries a sql datasource, brings in my data to
worksheet. Now, I am trying to use the formula sumproduct() t
retrieve the data I need based on two criteria. My problem is that th
data, the way that it is retrieved, is not readable by my formula o
more so returns a value of 0 within the criteria of my formula. Now
When i double click within the querytable (a specific cell) the data i
converted to: formulaR1C1= "Text" and then becomes readable by th
formula.
Any suggestions would be helpful.
Patric
worksheet. Now, I am trying to use the formula sumproduct() t
retrieve the data I need based on two criteria. My problem is that th
data, the way that it is retrieved, is not readable by my formula o
more so returns a value of 0 within the criteria of my formula. Now
When i double click within the querytable (a specific cell) the data i
converted to: formulaR1C1= "Text" and then becomes readable by th
formula.
Any suggestions would be helpful.
Patric