Sum formula for CURRENCY cell type

Posted by: santoshi-fp on 8 September 2017, 2:54 pm EST

  • Posted 8 September 2017, 2:54 pm EST

    How can I write a formula for Currency cell type to calculate the sum of an entire column. I have tried "Sum(AV1:AV3)". Its not working at all. I am trying to add the sum formula in the column footer. Any help is much appreciated.
  • Replied 8 September 2017, 2:54 pm EST


    You would need to use the SetAggregationType method of the ColumnFooter class to add a formula in the column footer, that displays the sum of the entire column in the column footer. Please have a look at the following link which describes how you could add a formula to the ColumnFooter.

    Hope it will help you. Please let me know if you have any queries further.


    Manpreet Kaur

  • Replied 8 September 2017, 2:54 pm EST

    Thanks Manpreet. Its working now.
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels