Domenic,

Welllll, the formulae I have had in my workbook are correct. There must be
a setting or something on the specific worksheet that I am working in for
this not to be working.

Just to check that I had my formula correct, I input the exact scenario I
gave you into a new worksheet in my workbook and as expected it worked fine.

Then, I put the exact information on the worksheet I am needing the formulae
on and it shot craps again. All is working excpet it is not excluding the
cells we are indicating (i.e. f4). Don't have a clue as to why it is
occurring on this particular worksheet?!?!?

"Domenic" wrote:

Okay, in this case, you would use the following formula...

=IF(INDEX(FREQUENCY((F1:F3,F5),0),2),AVERAGE(IF((1-ISNUMBER(MATCH(ROW(F1:
F5),{4},0)))*(F1:F50),F1:F5)),"")

....confirmed with CONTROL+SHIFT+ENTER. Note that the number in the
array constant --- {4} --- determines which row to exclude, in this case
row 4 or F4.

If, for example, you wanted to exclude rows 2 and 4 (F2 and F4,
respectively), then you would change the array constant to {2,4}. Does
this help?

In article ,
"Coal Miner" wrote:

Ok! Took care of that problem but it is not excluding f39,f40,f41,f46,f47.
I see where the values of {5,6,7,12,13} should take care of this. Maybe we
got off course somewhere. Here is a simple version of what I want to do

f
1 10
2 12
3 0
4 0
5 7

OK, I want the average of f1,f2,f3,and f5 but do not include the zero value
located in f3 in the average calculation. Also, do not include f4 in the
calc. This is overly simplified but if you get this to work, I could get the
remainder.

Thanks again.