Subtotal, Sumif Only Showing Visible

I have read through the posts on with subtotal and sumif in the forums, but can't get this one working.

I have a workbook that is pulling in data from MSSQL 2005. I am trying to show a total at the end of a column based on if a second column contains a certain value. I can do this with sumif, but when I run filters it doesn't change the totals.

So for instance

G H J
$10.00 DAP 01/01/2005
$10.00 DAP 01/01/2005
$10.00 DAP 02/01/2005
$10.00 JBB 02/01/2005


If I want the total for column 1 where all column H = DAP then I use this:

=SUMIF(H2:H3058,"DAP",G2:G3058)

and I get a total of $30.00, but when I filter add a filter and only pull dates from Jan 01/2005, then it still shows $30.00. I am trying to get it so that when I apply the filter it shows $20.00.

Any help would be greatly appreciated.

Holy crap.... That worked... Thank you. Now I am just trying to figure out what it says. :D

Sorry VBA Noob. I didn't realize I was doing anything wrong. I have been posting in multiple forums for 8-9 years now and you are the first person to ever point out that posting on different sites is cross posting. I thought that had to do with posting in multiple forums on the same site. There are just so many people out there that are so stuck on themselves and think they are too smart to give real answers and only give sarcastic put downs to people in forums, or people that think they know all the answers and give wrong ones that I find it easier to get a good answer by posting in multiple places. I will remember your advice on posting going forward.



Thanks for the answers NBVC. Your solution worked perfectly.