Hi Fatboy10,

Welcome to the forum

Try looking at Subtotal function which works with visible cells.. thanks


Regards,
DILIPandey

<click on below 'star' if this helps>