countif & sumif formula with filter ?

hii all ,
i am using these formulas for my work sheets, in need to do it changes amounts when i do the filter in my summary , any body help me for this plzzz

=COUNT(IF((SUMMARY!$F$6:$F$3033="PURCHASE")*(SUMMARY!$G$6:$G$3033=A6),1))

=IF(A6="","",SUMIF(SUMMARY!G$6:G$9733,A6,SUMMARY!L$6:L$9733))

thanks

Try:

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.