Year Function

Posted 4 months ago by Daryl

D
Daryl
Un Answered

0 Votes

Hi,

This is a request to add a function that adds up all the months of a year to provide a total for that year.  Right now I have to pull 12 months then create a formula that adds up the months.  It would be a huge help to have a function that does this.  Thanks!

0 Votes


2 Comments

Sorted by
D

Daryl posted 4 months ago

This is perfect!  Thanks so much!!!

0 Votes

Gabriel Michaud

Gabriel Michaud posted 4 months ago Admin

Hi Daryl,


Are you using the =ACCOUNTTURNOVER() function? This function has both a From and a To period argument, allowing you to get the total turnover for a year. For example:


=ACCOUNTTURNOVER("Demo", "ACTUAL",, "40000", , , "01-2019", "06-2019")


...will give you the total for the first 6 months of the year for account 40000.


Is this what you'Re trying to achieve?


0 Votes

Login or Sign up to post a comment