How to create a rolling 30-day sum in LibreOffice Calc

This is a LibreOffice Calc tutorial covering how to create a rolling sum. The tutor starts of by using the SUMIF function to demonstrate how it works. The tutor then concatenates (joins together) the SUMIF functions and the TODAY() functions to capture the last 30 days of data. The tutor then repeats the whole process using named ranges. The final part of the video covers how to use the AVERAGEIF function. The tutor captures the average for the last 30 days and displays the overall average and the overall total. How to create a rolling 30-day sum in LibreOffice Calc.
#calc

#libreoffice
If you want to support me, check this out:   / itseasy  

Classroom based courses can be arranged at https://www.itseasy.co.uk/

Courses are available through Microsoft Teams, Online and Face to face in the UK
Online courses at https://itseasytraining.teachable.com/


Udemy Courses https://www.udemy.com/user/stephen-sa...

Training Guide Books
Excel for New Managers
https://www.amazon.co.uk/Excel-New-Ma...
Microsoft Project Overview https://www.amazon.co.uk/Microsoft-Pr...
Microsoft Visio Basic https://www.amazon.co.uk/Microsoft-Vi...
Very cheap E_books are here:
Excel For New Managers https://payhip.com/b/IE4x
Microsoft Project Overview https://payhip.com/b/wY0m
Microsoft Visio Basics https://payhip.com/b/5XeV
Microsoft Access Introduction https://payhip.com/b/ynSL
A PowerPoint Overview https://payhip.com/b/YkQv