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
Darylposted
4 months ago
This is perfect! Thanks so much!!!
0 Votes
Gabriel Michaudposted
5 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:
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
Daryl posted 4 months ago
This is perfect! Thanks so much!!!
0 Votes
Gabriel Michaud posted 5 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