D
Diane
Listed below is a formula that I am using is various
worksheets of different sizes.
=SUMPRODUCT(--($N$8:$N$25000="Early"),SUBTOTAL(3,OFFSET
($N$8,ROW($N$8:$N$25000)-MIN(ROW($N$8:$N$25000)),,)))
I have it set up to sum from row 8 (which is constant on
all worksheets) through row 25000 (this row will change
from worksheet to worksheet). Is there a way to
incorporate a formula into this one that will only sum to
the last non-blank row (there are no blank rows above the
last line of data).
Thanks for your help!
worksheets of different sizes.
=SUMPRODUCT(--($N$8:$N$25000="Early"),SUBTOTAL(3,OFFSET
($N$8,ROW($N$8:$N$25000)-MIN(ROW($N$8:$N$25000)),,)))
I have it set up to sum from row 8 (which is constant on
all worksheets) through row 25000 (this row will change
from worksheet to worksheet). Is there a way to
incorporate a formula into this one that will only sum to
the last non-blank row (there are no blank rows above the
last line of data).
Thanks for your help!