Sumproduct Indirect additional condition

Hello,

I have a formula that that will add up all the items in $HK$15:$HK$39 where $HP$15:$HP$39 is equal to $W$6.

SUMPRODUCT(IFERROR(SUMIFS(INDIRECT("'"&TabNames&"'!"&"$HP$15:$HP$39"),INDIRECT("'"&TabNames&"'!"&"$HK$15:$HK$39"),$W$6),0))

What I would like to do is add in this new range $HF$15:$HF$39 into the equation where it is matching cell $AG$4.

So basically I would be doing multiple criteria. If $W$6 is found in the range $HP$15:$HP$39 and then if $AG$4 is found in the range $HF$15:$HF$39, bring me the number

Is there a way to do this?

It's always best to attach a sample of your file so we can look at play with that to get you a solution.
You should be able to do what you are wanting. You originally joined in 2012 and your profile says V2010. Is that still accurate or have you upgraded your Excel?
Please see the yellow banner at the top of the page for supplying a sample workbook.