aworthey
07-18-2016, 12:55 PM
Hello,
I'm trying to count visible columns in a row that are greater than 0. This formula works EXCEPT for the "visible" criterion:
=COUNTIF(F26:T26,">0")
I've found some discussions about using an unusual behavior of the OFFSET function. I've tried a few things but I'm not quite understanding it. Here's my attempt:
=SUMPRODUCT(SUBTOTAL(103,OFFSET(A2,,COLUMN(F26:T26)-COLUMN(F26:T26),,)),(F26:T26>0))
Does anyone have experience with this?
Thanks so much!!
I'm trying to count visible columns in a row that are greater than 0. This formula works EXCEPT for the "visible" criterion:
=COUNTIF(F26:T26,">0")
I've found some discussions about using an unusual behavior of the OFFSET function. I've tried a few things but I'm not quite understanding it. Here's my attempt:
=SUMPRODUCT(SUBTOTAL(103,OFFSET(A2,,COLUMN(F26:T26)-COLUMN(F26:T26),,)),(F26:T26>0))
Does anyone have experience with this?
Thanks so much!!