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