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.
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.