In the below formula I need to incorporate some sort of OR function to average rows that reflect APPLE "AND" RED that are ROTTEN OR FRESH. The way I have it below adds two averages together, which doesn't come up with the correct result. Any ideas?
=...