Hi, I'm new on here. I have no excel training but I've just tried to self-teach along the way. Now I'm stuck! If anyone could help I'd be very grateful.
I have a formula which I know works:
=SUMPRODUCT(SUBTOTAL(2,OFFSET(I5:I627,ROW(I5:I627)-ROW(I5),0,1)),--(I5:I627=1))
This counts the number of visible entries in a filtered column that are equal to the value '1'.
I tried to adapt this to row H & wanted to count the number of visible entries (after filtering) that were greater than 1, but less than 2, so I tried;
=SUMPRODUCT(SUBTOTAL(2,OFFSET(H5:H627,ROW(H5:H627)-ROW(H5),0,1)),--(H5:H627>1.0,H5:H627<2.0))
What have I done wrong?
Thanks,
Crabman9
Bookmarks