Average.If using two columns and Matching Criteria

[dialmaco]

Hi,

I have been trying to do the avareza of two columns if they match a certain criteria. My aim is to know the average from the third and fourth column if it is "terça-feira". However, with the formula "=MÉDIA.SE($A$2:$A$16;B19;C$2:D$16)" it only returns the average from the first column. Any way to do this?

Thanks in advance.

 

[Aladin Akyurek]

Can you post a 5 rows sample along with the desired result for that sample?