TRIMEAN on Filtered lists

Excel 2016 MS OFFICE 365
Hi there, I am trying to use the TRIMEAN function on a pretty basic filtered list, so far I have the following array formula:

{=TRIMMEAN(IF(SUBTOTAL(2,OFFSET($B$2:$B$226,ROW($B$2:$B$226),,1)),$B$2:$B$226),$C$236)}

Where column C is a number set and C236 is the Trimean %.

I seem to be getting mixed data results; any idea where I have gone wrong? I have looked online and have found an alternative formula {=TRIMMEAN(IF(SUBTOTAL(3,OFFSET($B$2:$B$226,ROW($B$2:$B$226)-ROW($B$2),0,1)),$B$2:$B$226),$C$236)} but this does not seem to help.

Thanks in advance.

Awesome chaps, works correctly now. Thank you!