How to average a dataset in Excel using AVERAGE and AVERAGEIF
Sum and count aside, let's now talk average. Averages, just like sums, can be easily calculated for any dataset, no matter the size, easily in Excel. Feel free to also set a certain criteria to compute the averages only for values that meet that given criteria. Follow the video for how it's done. Use the links below to take a closer look at some of the helper functions used in the video.
For the MATCH function, check out this video:
• How to search for values using the MATCH a...
For the INDIRECT function, check out this video:
(To be published and updated on schedule)