Hi guys,

I noticed that this issue has been discussed earlier but I just don't know how to apply this subtotal etc. part to my formula. Little bit too tricky for me. So, I need to do Sumproduct for visible rows only and code below needs some changes.

ActiveCell.Formula = "=sumproduct((l2:l" & last & "=""X2"")*(w2:w" & vika & "=""abcdef"")*(M2:M" & last & "))"
Cheers,

Ville