Hi,
Is there a way to sum in an excel formula the results from a table created from a query. In most cases you would just create a footer and place a sum value like $=sum(aDataSet.aField.Value). However, I want my users to be able to change the values in the table and have the sum change using excel calculations when they do this.
I could place something like =sum(C:C) and sum all the values in column C but that basically makes column C off limits for anything else. Any ides are appreciated.
Thanks,
Dean