Need updated Sum when data is filtered

[Zed.jpeg]

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.

[Zed.jpeg]

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.

[AliGW]

Administrative Note:

Welcome to the forum.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-gen...-to-table.html