K
katagrga
I am trying to get a count of the subtotaled cells that have value of "1". I
have searched through previous posts and have not been able to get any of the
formulas to return the correct value. The formulas I have tried are and the
returns I received are as follows:
=SUMPRODUCT(--(D26303="1"),SUBTOTAL(3,OFFSET(D2,ROW(D26303)-ROW(D2),)))
=SUMPRODUCT(SUBTOTAL(3,OFFSET(D26303,ROW(D26303)-MIN(ROW(D26303)),,1)),--(D26303>="1"))
both returns a 0. without the "' returns 4991 which is the number of
subtotals.
=COUNTIF($D$2:$D$6303,"1") returns 5115
I've tried several others as well. Any help is greatly appreciated.
have searched through previous posts and have not been able to get any of the
formulas to return the correct value. The formulas I have tried are and the
returns I received are as follows:
=SUMPRODUCT(--(D26303="1"),SUBTOTAL(3,OFFSET(D2,ROW(D26303)-ROW(D2),)))
=SUMPRODUCT(SUBTOTAL(3,OFFSET(D26303,ROW(D26303)-MIN(ROW(D26303)),,1)),--(D26303>="1"))
both returns a 0. without the "' returns 4991 which is the number of
subtotals.
=COUNTIF($D$2:$D$6303,"1") returns 5115
I've tried several others as well. Any help is greatly appreciated.