I have been trying to use AVERAGEIFS formula to find a range of prices for my data but have failed to solve it.
The data is as follows
ExcelFormula.png
I want to find out the average prices of 32 inch (In the actual sheet there are multiple sizes e.g 30,34,40, etc) that is GM Type but including ones that are labeled GM 2K and GM 4K. Which formula should be used? I am a beginner in Excel FYI.
Last edited by sbea114; 07-24-2017 at 10:57 PM.
Edited to allow for not including GM UWQHD:
=AVERAGEIFS(L11:L35,A11:A35,32,B11:B35,"GM*",B11:B35,"<>"&"GM UWQHD")
Last edited by gak67; 07-24-2017 at 11:13 PM.
Please add reputation by clicking on the * if I have helped.
Please mark the thread SOLVED if your issue has been resolved.
Thanks, Glenn.
Thank you for your help,
In addition, if in the same way I want to find the average of 32 inch/4K or 2K(Including any labels that have these, e.g "GM 2K") should I replay "GM*" with the corresponding categories?
Much appreciated!
Yes. I would change it like:
=AVERAGEIFS(L11:L35,A11:A35,32,B11:B35,"*K")
You would just need to make sure there were no other types that contained a 'K'.
Thank you very much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks