can make errors
Guest wrote on December 31, 1969 19:00 EST |
Error: #DIV/0!
When: =AVERAGE(IF(RANGE1>F13;RANGE2))
if no culoumns are greater than F13 |
Diferent answer
Dwwon wrote on December 31, 1969 19:00 EST |
| I am getting 215 not 330? |
I also get the value "215',,, BUT,,,read on
jay wrote on September 08, 2006 13:06 EST |
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' ? |
Edit and Array Formula
Chris wrote on December 31, 1969 19:00 EST |
| When you edit and Array Formula you must hit CTRL+SHIFT+ENTER, NOT just ENTER. |
Calculating the average of numbers meeting criteria
sivanaresh wrote on September 10, 2006 11:00 EST |
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. |
Calculate the average of numbers meeting TWO criteria
Stephanie Davis wrote on September 29, 2006 14:35 EST |
| 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 |
array
fankairong wrote on October 05, 2006 18:35 EST |
| when you finish the function,use CTRL+ALT+ENTER , |
Try this!
Mauro Daud wrote on October 10, 2006 05:21 EST |
: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) |
Gabriela wrote on October 11, 2006 20:12 EST |
| Did you try finishing it with CTRL+ALT+ENTER instead of just hitting Enter? |
The Basics of Finance: Financial Tools for Non Financial Managers
