Hi Chandra

Thanks for your reply. I am looking to avoid using a pivot table for this purpose if possible. Normally I'm a big fan of using them.
Is what I want to achieve possible using only a formula?

Regards