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.
Try the AVERAGEIFS() function...
Also, your ranges need to be the same size
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi,
The comma vs semicolon determines if it is a Horizontal or Vertical array constant. Read
http://www.databison.com/excel-array...ray-constants/
And look at the section of Horizontal and Vertical Array constants. Squint to see "," vs ";" which is the difference.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Hi marvinP & FDibbins,
Thanks for reply. both not working, i dont know where is the wrong syntax? but the 3rd formula working fine. can u please help to make correction
Last edited by Faridwahidi; 05-16-2014 at 12:58 AM.
Does
=AVERAGE(IF((H515:IW572=H503)*((H519:IW576="January")+(H519:IW576="February")),H524:IW581)) CRTL + SHIFT + ENTER
work?
maybe you missed the close parentheses in your syntax
......*(H519:IW576={"January","February"}here
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Hi MarvinP,
=AVERAGE(IF((H515:IW572=H503)*((H519:IW576="January")+(H519:IW576="February")),H524:IW581)) CRTL + SHIFT + ENTER working fine
Hi vlady,
what do you means by close parentheses in my syntax? it seems to be correct formula.
AVERAGE(IF((H515:IW572=H503)*(H519:IW576={"January","February"},H524:IW581))) CRTL + SHIFT + ENTER
Please also help me in VBA code if more than one criteria in the same range to be counted
http://www.excelforum.com/excel-prog...ria-range.html
Hi MarvinP,
I have replied on the above, It works for
=AVERAGE(IF((H515:IW572=H503)*((H519:IW576="January")+(H519:IW576="February")),H524:IW581)) CRTL + SHIFT + ENTER
but on this formula not
AVERAGE(IF((H515:IW572=H503)*(H519:IW576={"January","February"},H524:IW581))) CRTL + SHIFT + ENTER
Please help, thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks