I have 2 columns in my excel sheet.and i add a pull down menu for each column.

M/H/S Status
Software EVT-Close
Mechanical EVT-Open
Mechanical DVT-Close
Hardware DVT-Open
Mechanical MVT-Open
Hardware MVT-Close

Result
EVT-Close 3
DVT-Close 2
MVT-Close 1
EVT-Open 3
DVT-Open 2
MVT-Open 1
Mechanical 3
Hardware 4
Software 5

I facing problem: how to calculate the percentage for software open cases.
(Software Open)?

Book2.zip