Comments for SQL 2 Excel - Formulas at http://joomla-r-us.com , comment 1 to 5 out of 5 comments http://joomla-r-us.com Sat, 04 Feb 2012 16:56:32 +0100 FeedCreator 1.7.3 http://joomla-r-us.com/faq/70-sql-2-excel-formulas#comment-578 @fredhouse: See above how to specify which columns contains formulas! -Mats - admin Sat, 05 Mar 2011 10:25:40 +0100 http://joomla-r-us.com/faq/70-sql-2-excel-formulas#comment-577 Help Please Formulas do not seem to work for us... We have an UNION of several SQL statements that works fine. UNTIL we put in a formula. SELECT "","zzz" AS StaffName ,"82" AS Job,"","TOTALS","","","=SUM(H2:H48)" AS FORMULA,"" simply puts the plain text [b]"=SUM(H2:H48)"[/b] into the cell and not the formula. - fredhause Fri, 04 Mar 2011 19:01:34 +0100 http://joomla-r-us.com/faq/70-sql-2-excel-formulas#comment-394 I would like to do a simple calculation at the end of a column. What would the formula be for an extra cell? I tried something similar to the above : SELECT AmountUS, '=Sum{colid}' AS FORMULA FROM projdb_proj_data But that didn't work. Also tried the standarde excel formula =Sum(), but that didn't work either? Do you have a document with sample formulas other than this page? Let me know, Jeff - jeffreyd65 Sun, 22 Aug 2010 13:00:52 +0100 http://joomla-r-us.com/faq/70-sql-2-excel-formulas#comment-259 @mhpbkk : With SQL 2 Excel Pro you can add "Extra Cells" with data, formulas, text, results from SQL queries etc etc, at any place(s) in the spreadsheet, as long as the cell hasn't been written to before. You can't do it with the free version though. -Mats - Mats @ Joomla-R-Us Sun, 21 Mar 2010 17:29:41 +0100 http://joomla-r-us.com/faq/70-sql-2-excel-formulas#comment-257 hi, is it possible to insert a sum of a column into one specific cell? eg. in the example above put the sum of column 2 into cell B12...? - mhpbkk Sun, 21 Mar 2010 15:15:25 +0100