Autohide blank rows in a table linked with dropdown menu selection

[skf786]

Hi, I have a profit and loss statement linked with a drop down list section. Based on each selection, some rows ( data cells) are left blank even though they have sumifs formula in them. Row titles will not be blank. I want these full rows to be hidden automatically once a selection is made from the drowpdown list.

Thank you in advance

Khalid