.
Hi,
The formula showed below is located in cell B1 and works OK. But, I would like help me to improve it.
What I am pretending to do is subtotal all registers in column A except the last register=SUBTOTAL(9,$A$21:$A$65536)-OFFSET($A$21,(COUNTA($A$21:$A$65536)-1),0)
(from A21 ahead).
Thanks in advance.