SUBTOTAL

Use command of SUBTOTAL in Excel instead of SUM, COUNT, MAX, etc. 
............. to ignore rows hidden by a filter or to ignore manually hidden rows.

Suppose we have following table in excel -


In above table column A is of name & Column B is of Amount.
if we total all total is 1430000.

Now we see in Column A shows various name like Mohan, Sohan, Ram, Jayant &  Ramu. If we use filter in ROW 2 & click on name of Jayant the total is 1430000.
whereas Jayant total is 270000/-.
To get Correct Jayant total we use subtotal instead of Sum.
following are steps -
before filter we use subtotal command as follows -
               use command = subtotal(9,B3:B14)




Now we use filter in ROW 2 we get correct total of any name like as follows -