Hi,

I have series of rows with the SUBTOTAL() function at the end and followed
by blank row seperating the product categories. I want to fill the formulae
down without deleting Subtotal() function and avoiding the blank rows to be
filled in. Can anyone help?

Regards,
Fuad