How to add column values in excel

[arivu96 (Arivazhagan A)]

Hi @neerajmca5,

Refer this post,

Write excel formula for row count

Hi, Facing problem while trying to set a formula in a desired cell(AZ1) of the sheet. The intention is to get the the last row with values in it, add +1 to it and use the new row to continue writing to the sheet. Formula : =MATCH(REPT(“z”,255),A:A) + 1 The C# escape sequence doesn’t work over here and unable to assign the same in variable. Tried to have the formula in Notepad and then copy the contents over to the cell but its giving error like “System.ServiceModel.FaultException: …

How to Apply formula on DataTable values

Hi @Sandeep I don’t know the formula part. you can check it on google but i can help with programmming calculation part. Please find this attached solution and let me know. Solution.zip (19.1 KB)

Regards,
Arivu