Sumproduct with out filtering effect

[pedjvak]

Hi
I am new in excel
please help me on my problem
I want to use sumproduct formula in my data and when I filtering my data sumproduct changed after my filtering plz show me on sumproduct formula not adding a column and then use subtotal and like these method
thanks in advanced

 

[BBD]

Hi pedjvak,

It will help us to understand the issue if you paste a file.

 

[Debraj]

Hi pedjvak,

Welcome to the forum..
As a new user you might want (I'd say should and must) read this:
http://chandoo.org/forum/forums/new-users-please-start-here.14/

And regarding your issue, everything is explained here.

let us know.. if you are facing any issue..