How to write a AVERAGEIF formula in Excel (with examples)

Подписаться 6 тыс.

Просмотров 5 тыс.

50% 1

AVERAGEIF calculates an average for the figures in list B where corresponding cells in list A meet a given criteria.
This video walks you through how to create a number of different AVERAGEIF formulas from scratch.
Add your questions and comments below. I read and respond to every comment personally.
And don't forget to subscribe and hit that bell to be the first to get notified when new videos are dropped.
USEFUL LINKS:
DOWNLOAD the demo spreadsheet
officemastery....
SHARE this video with your social network:
• How to write a AVERAGE...
SUBSCRIBE if you want to see more content like this
www.youtube.co...
Hire Jason to fix your broken spreadsheets or to get private 1-on-1 Zoom coaching
trst.com.au/mi...
ABOUT THE PRESENTER:
Jason Morrell helps people of all levels to leverage the power of Microsoft Office. Delivering training since 2002, he loves to simplify the hard stuff and provide helpful, actionable advice that has been proven to slash hours from daily computer tasks. Jason lives with his wife and 4 kids on the beautiful Gold Coast in Queensland, Australia.
LET'S CONNECT!
officemastery.com (free training on the blog)
/ officemastery
/ jkmorrell
/ jasonmorrell
Have a fantastic day!

Опубликовано:

29 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 6

@JasonMorrell 4 года назад

I hope you found value in this video. Feel free to post your questions and feedback in the comments below. I respond to every comment. Have a fantastic day. Jason

@JasonMorrell 4 года назад

👍

@lenepienaar2863 2 года назад

How do you average more than one column, mine doesn't give an error but the calculation is incorrect if I just expand the 'Average Range' to more than one column?

@JasonMorrell 2 года назад

Hi Lene. To calculate an average of the figures in one column where one or more conditions are true, you need to use AVERAGEIFS. The syntax is as follows: =AVERAGEIFS(range_to_average, criteria_range_1, criteria_1, criteria_range_2, criteria_2, criteria_range_3, criteria_3 etc. just keep pairing a criteria range with a criteria for as many as you need.) I have a video here that demonstrates it (ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-iw-8lQ0w0Ss.html). Check out the video notes to download a demo spreadsheet. I hope that helps. Jason

@lenepienaar2863 2 года назад

@@JasonMorrell Hi Jason, I want to average more than one column, (Different team dimensions scored using multiple questions per dimension for multiple teams) but after going through countless forums, it seems that is just not that easy in Excel without a few steps/multiple functions! We will probably move our analysis to R or another software!

@JasonMorrell 2 года назад

Why not create an additional calculation column that first totals the values from the multiple columns you are trying to average, then apply the AVERAGEIFS to the new column ?