Sum Is not working in Exported Excel using classic asp (vbscript)

See more:

ASP

VBScript

MS-Excel

I have a project in which we are exporting a page into excel using vbscript. I used the follwing code to export:

Response.Buffer = True

       Response.ContentType = "application/ms-excel"
       Response.AddHeader("Content-Disposition", "attachment; filename=""" & filename & """")
       Response.ContentEncoding = System.Text.Encoding.UTF8

       Response.Charset = ""
       EnableViewState = False

Using this code the excel is downloading fine and data also fine, but when i select the cells which have numbers, its not showing the Sum and Average and all it only shows Count. I guess that the cells are in text format.

Since i am new to this, kindly tell me the Solution.

Thank You.