average if, multiple conditions... possible?

[Jennifre]

First of all thank you in advance. I have learned so much from the answers I've gotten from this board, thank you to all who've responded to my dorky queries here!

Yet, this one's got me. I have used sumproduct with multiple criteria, and how to use AverageIfs, but I'm hoping to combine that by using an averageif, with multiple criteria. What I have tried, doesn't work.

If anyone can help, I feel very grateful -- thank you for your syntax help!! My unworking effort so far:

{=AVERAGE(IF((ap$2:ap$1364=3,4),$cf$2:$cf$1364=1,2))}

 

[barry houdini]

To restate (hopefully correctly), I need the percentage of AP values 3 or 4 whose rows feature CF values 1 or 2.

If that's the requirement, then if there are 10 rows where 3 or 4 appears in column AP....and out of those 10 rows 2 of the column CF values are 1s and 2 are 2s then that would be a percentage of 40%.

You can do that using AVERAGE, i.e.

=AVERAGE(IF((AP2:AP100=3)+(AP2:AP100=4),IF((CF2:CF100=1)+(CF2:CF100=1),1,0)))

confirmed with CTRL+SHIFT+ENTER

 

[Jennifre]

Biff, I think that what you have given me will do the trick (need to check it, but I think it looks like it should work) -- THANK YOU SO MUCH!!

 

[T. Valko]

Biff, I think that what you have given me will do the trick (need to check it, but I think it looks like it should work) -- THANK YOU SO MUCH!!

Good deal. Thanks for the feedback!