I am using excel(2003 and 2007 versions) to upload to and display informtion from a SQL(2005) table. The SQL stores budget information. There are two main identifers in the table: 1) a Service Code and 2) a specific Project Code. When the person uses the excel file, they upload information regarding a specific project and they go to another sheet that shows totals from a number of different projects that correspond to that Service. Right now to display the overall budget info, I have it set up like this:
1) I excel bring in the entire SQL table (which has about 100 rows/60 columns of data
2) Based on a project code field that that it is in a excel cell as well as the SQL table, I have a number of "SumIfs" formulas to populate certain cells in excel that display the overal totals for different areas for that service based on the individual projects.
Needless to say, the excel file is getting very large. Is there a way to have these "sumifs"/queries occur on the SQL side so the only information brought it is based on the "Service" code that is selected by the user. Also, say I want cell C6 on the "Budget Summary" sheet to display the grand total for the Service from the Office Expenses column in the SQL table, is that possible?
I hope I made sense. Thank you for your help, this is all new to me.