Hi,
I need to be able to get the average of a range of cells from cells L6:L213, the criteria is that cells D6:213 have to be greater than Cell G6 (which is 12000) and ignore a 0 in any cell in the range of L6:L213. Bellow is what I have tried so far which displays #VALUE. Sorry if my explanation is difficult to understand, I am fairly new to EXCEL.
=AVERAGEIFS(Standard!$L$6:$L$200,$D$6:$D$213,">"&$G$6,Standard!$L$6:$L$213,"<>0")
I am using office 2007
Bookmarks