Year Function

General
1

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!

2

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?

3

This is perfect! Thanks so much!!!