Excel Basics: How to calculate the average of rows and columns using the AVERAGE function

preview_player
Показать описание
This short video details how to calculate the average of values in an Excel column, and an Excel row, or across both rows and columns (a range of values).
Рекомендации по теме
Комментарии
Автор

Sir you saved me half an hour of manually averaging 366 rows of data I salute you with Absolute gratitude

cheshiure
Автор

Great. Many thanks from Lancashire UK.

edwinhardman
Автор

Thanks, just what I needed for this morning....from here in Ohio

gwennbair
Автор

I have similar data frame eg 56 X 56 but i have to take avg of 8 X 56 data frame is there any conditional formula to take such average consecutively like in mine case i have to take 7 times average 8 X 56 data frame.
1:7, 8-15...till 49-56

devawratvidhate