Quote:
Originally posted by Epidemic
=IF(G14="Total",SUM(OFFSET(E7,-4,4):OFFSET(E7,6,4)),"")
Not sure if this does what you want but here give this a whirl.
ps this is a formula of course.
I did not generate a macro for this one. |
This one sitll only sums I3:I13,,, I want it to sum up to the top #, for instance I put a # in I2,, it doesn't pick it up... You know how when you hit the AutoSum button it sums up to the very top of the #'s, even if there is 3 #'s or 5000, as long as there's no breaks... Thanks!