@@RenierWessels I totally agree with the comment above! I also tried the SumIF&IFS and as you well said, they didn't work. So I am so glad I found this video.Thank you so much!
I've been having trouble with a large range of data; trying to average results from 3 brands, three auditors and their audit scores. Each time I used averageifs it returned a #VALUE! error. Your last solution worked. Thank you so much... just need to build my dashboard now!!!
@@RenierWessels Hello There thank you for that amazing equation first, I tried using this in average ifs but it always returns this error "Argument must be a range" Is there a solution for that?
This is the exact same issue I've been facing and trying to solve since last week.🤩Thank you very much for sharing. This is very informative for me👍 however I have the 2013 version of Excel so the first solution (filter function) I can't use🤯 and the third solution is easy but I can not change the format of my database.😶🌫 Apart from that i have same but little different issue, i have dates where you have put months and i have to take out average by months and its not working i kindly request you to help me out.🤞 I will send you my excel sheet🤲 Thanksssss
![BLACK BAG - Official Trailer [HD] - Only in Theaters March 14](http://i.ytimg.com/vi/Du0Xp8WX_7I/mqdefault.jpg)
I'm usually skeptical of RUclips videos exactly answering the question I have, but this nailed it 100%. Thank you so much!
Glad to hear it and thank you for the feedback!!
@@RenierWessels I totally agree with the comment above! I also tried the SumIF&IFS and as you well said, they didn't work. So I am so glad I found this video.Thank you so much!
Thanks for your comment @@Joanna-JohnJuan6.40. I'm glad it was helpful.
Thank you Renier. Please keep sharing these insightful stuffs.
Your videos are very didactic, good solutions, keep up your good work, you won another subscriber! Thanks...
Thanks for your comments Luciano. I’m glad if I can add value. There will be a new video on Power Query out in 8 hours from now!
I've been having trouble with a large range of data; trying to average results from 3 brands, three auditors and their audit scores. Each time I used averageifs it returned a #VALUE! error. Your last solution worked. Thank you so much... just need to build my dashboard now!!!
Thanks for the feedback. I’m so glad it helped!!
good stuff Renier!
Great work with the video, keep it up.
What should I do if I want to average the data of month JAN and Feb, excluding March, through the use of the last shown solution (AVERAGEIFS) ?
Hi. You would just add another criteria.
@@RenierWessels Hello There thank you for that amazing equation first, I tried using this in average ifs but it always returns this error "Argument must be a range"
Is there a solution for that?
U r new in youtube and best of luck dear
Thanks so much! Would this work for me if my goal is to change A, B or C to a range of values like "greater than 1 & less than 3"?
Yes. That should work perfectly.
This is the exact same issue I've been facing and trying to solve since last week.🤩Thank you very much for sharing. This is very informative for me👍 however I have the 2013 version of Excel so the first solution (filter function) I can't use🤯 and the third solution is easy but I can not change the format of my database.😶🌫
Apart from that i have same but little different issue, i have dates where you have put months and i have to take out average by months and its not working i kindly request you to help me out.🤞
I will send you my excel sheet🤲 Thanksssss
Hi Oza. Sounds like you need a pivot table in your case, but feel free to share your sheet!! Happy to help.
@@RenierWessels I prefer to take average by formula instead because i have 21 datasheet like this🤯, I have mail you the one datasheet .....Thanks👍
@@RenierWessels I hope you got the mail....📧
Here