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.
Bookmarks