Hi,

anyone please help me.

both below code not working

AVERAGE(IF((H515:IW572=H503)*(H519:IW576={"January","February"},H524:IW581))) CRTL + SHIFT + ENTER
AVERAGE(IF((H515:IW572=H503)*(H519:IW576={"January";"February"},H524:IW581))) CRTL + SHIFT + ENTER


but this one is ok

where M502= January, M502= February

=AVERAGE(IF((H515:IW572=H503)*((H519:IW576=M502)+(H519:IW576=M503)),H524:IW581)) CRTL + SHIFT + ENTER


Please help.