Need updated Sum when data is filtered

I'm trying to write my formula to update my totals when I apply a filter to the column.

Currently I'm using COUNTIF($B$17:$B$1000,"1")

"1" in this instance is a name and NOT intended to be a value. I need the Sum to land in B3.

I've been trying to use =SUMPRODUCT with no success. Unfortunately, this is a new formula for me.

=SUMPRODUCT(SUBTOTAL(3,OFFSET($B$17:$B$1000,ROW($B$17:$B$1000)-ROW($B$17),0,1)),--($B$17:$B$1000="1"))

This formula was found on another forum and I attempted to customize it. When used it returns a total of "0"


Any help would be greatly appreciated.

I'm sorry I think I posted this in the wrong place. I can't figure out how to delete it. I reposted it to the correct location.