Using TRIMMEAN on a selection of data

For quicker and better help on your question, read the link below.

http://www.excelforum.com/the-water-...-question.html

Reading your story i think i should solve that with pivot table.

Hi & welcome to the forum

i would request you to pls post small sample of your workbook, to understand your requirement & output clearly

pls remove all sensitive data before posting your workbook

Thanks,
A

Hi,

Difficult to confirm without seeing a sheet, but your formula will in any case fail on principle as you are attempting to pass arrays into a non-array formula.

As an example of what I mean, a formula such as IF(data!$G$2:$G$708=$A2..., if non array-entered, will not, as you would hope, test whether all cells in the range data!G2:G708 are equal to A2, but simply test this condition on the first element of that array, i.e. whether data!G2=A2.

In light of this (and again, I can't be sure as you were not kind enough to post a sample sheet), perhaps this array formula (confirm with CTRL+SHIFT+ENTER, not just ENTER):

=TRIMMEAN(IF((data!$G$2:$G$708=$A2)*(data!$A$2:$A$708=B$1),data!$I$2:$I$708),0.2)

Regards