Forum Discussion
silversurfer1950
Mar 09, 2020Copper Contributor
Divide one range of cells by another
I have a spreadsheet with a lot of numerical entries, split into months. I need to calculate averages, over a range of time, using the monthly totals. This means that I need a formula which will al...
SergeiBaklan
Mar 09, 2020Diamond Contributor
Perhaps AVERAGIFS() function will help
- silversurfer1950Apr 13, 2020Copper Contributor
Sorry about the long delay in getting back to you. I didn't quite understand you answer but it led me to finding the average function in the drop-down on the toolbar, which worked perfectly. Thanks!