» Calculating the Average for Numbers Meeting Specified Criteria

Error: #DIV/0!
When: =AVERAGE(IF(RANGE1>F13;RANGE2))
if no culoumns are greater than F13

I am getting 215 not 330?

Hi all,

I too get the value of "215" in cell C2 (which contains the formula as: =AVERAGE(IF(A2:A7>B2,A2:A7))

However, when I examine the formula using the fx icon (insert function) on the data entry menu bar, which brings up the "Function Arguments" pop-up window, it indicates that the formul result is "330"... This is strange,,,does anyone have a clue as to 'why' the displayed data in the cell is 215 and not the 330 as shown for a 'Formula result' ?

When you edit and Array Formula you must hit CTRL+SHIFT+ENTER, NOT just ENTER.

I am getting 215. When I tried to evaluate as to why it is 215 and not 330, the first validation of the function in the if block is to see if A2>200, and just becuase it is returning true, the Average function is calculating the average for the rest of the values (A2:A7).

Again, as Jay said earlier, if we see the value using function fx (Insert Menu), it is displaying 330.

I use this formula =AVERAGE(IF(AG2:AG92="yes",Y2:Y92)) to average a set of numbers and it works. Now I need to add one more criteria met before calculation the average. I need the one column to = "Yes" and other column to be = to a certain name i.e. John Doe. I tried using =AVERAGE(IF(and(U2:U92=T96,AG2:AG92="yes"),Z$2:Z$92)) were T96 is a certain name, but it doesn't work. Can anyone help me out. Thanks. sd

when you finish the function,use CTRL+ALT+ENTER ,

:rolleyes: It is necessary in this formula to put the criteria in the cel (for example >200):

Prices Criteria
500,00 >200
200,00
150,00
40,00
230,00
110,00
260,00
Formula result [COLOR="Red"]330,00 [/COLOR]
=SUMIF(A2:A8;B2;A2:A8)/COUNTIF(A2:A8;B2)

Did you try finishing it with CTRL+ALT+ENTER instead of just hitting Enter?