Hello, I have looked for a few hours for a solution and am quite stuck on this one! Any help would be much appreciated.
I am looking to find the average of all the cells in column A that meet the following conditions. If they don't meet them, they don't get averaged.
Thank you!!
I am looking to find the average of all the cells in column A that meet the following conditions. If they don't meet them, they don't get averaged.
- Anytime column A is greater than 0.5, average it (regardless of anything else)
- Anytime column B is greater than 6, average corresponding column A cell (regardless of anything else. e.g. col A cell could be less than 0.5)
- Another way you could put this is average all of column A except the cells where A < 0.5 AND B < 6
- column A = wind speed
- column B = temperature
Thank you!!