# Finding the correct % value

#### colin5392

##### Board Regular
I have 20 assets (devices)

9 of the devices have vulnerabilities. Device 1 has 8 x critical vulnerabilities and 20 x High vulnerabilities.

How do I correctly determine the true percentage values of Critical vulnerabilities and High vulnerabilities against number of assets with issues identified and the total number of devices?

### Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

#### tyija1995

##### Well-known Member
Hey is this something you're after?

 A B C D E F 1 Device Crit V High V Count V Crit V % High V % 2 Device 1 8 20 1 28.6% 71.4% 3 Device 2 0 4 Device 3 0 5 Device 4 0 6 Device 5 0 7 Device 6 5 13 1 27.8% 72.2% 8 Device 7 0 9 Device 8 3 7 1 30.0% 70.0% 10 Device 9 0 11 Device 10 2 7 1 22.2% 77.8% 12 Device 11 0 13 Device 12 7 10 1 41.2% 58.8% 14 Device 13 0 15 Device 14 8 8 1 50.0% 50.0% 16 Device 15 5 3 1 62.5% 37.5% 17 Device 16 1 7 1 12.5% 87.5% 18 Device 17 0 19 Device 18 3 1 100.0% 0.0% 20 Device 19 0 21 Device 20 0 22 45%

<tbody>
</tbody>

Columns B & C i populated with random data,

Column D (D2) holds the formula which can be copied down the D column: IF(COUNT(B2:C2)>0,1,0)

With D22 as: SUM(D2:D21)/COUNT(D2:D21)

Columns E (E2) holds the formula which can be copied down the E AND F column: IF(\$D2=1,B2/(SUM(\$B2:\$C2)),"")

#### colin5392

##### Board Regular
Hey is this something you're after?

 A B C D E F 1 Device Crit V High V Count V Crit V % High V % 2 Device 1 8 20 1 28.6% 71.4% 3 Device 2 0 4 Device 3 0 5 Device 4 0 6 Device 5 0 7 Device 6 5 13 1 27.8% 72.2% 8 Device 7 0 9 Device 8 3 7 1 30.0% 70.0% 10 Device 9 0 11 Device 10 2 7 1 22.2% 77.8% 12 Device 11 0 13 Device 12 7 10 1 41.2% 58.8% 14 Device 13 0 15 Device 14 8 8 1 50.0% 50.0% 16 Device 15 5 3 1 62.5% 37.5% 17 Device 16 1 7 1 12.5% 87.5% 18 Device 17 0 19 Device 18 3 1 100.0% 0.0% 20 Device 19 0 21 Device 20 0 22 45%

<tbody>
</tbody>

Columns B & C i populated with random data,

Column D (D2) holds the formula which can be copied down the D column: IF(COUNT(B2:C2)>0,1,0)

With D22 as: SUM(D2:D21)/COUNT(D2:D21)

Columns E (E2) holds the formula which can be copied down the E AND F column: IF(\$D2=1,B2/(SUM(\$B2:\$C2)),"")

I'll give it a go - thank you for your assistance

Replies
13
Views
245
Replies
1
Views
125
Replies
1
Views
142
Replies
1
Views
196
Replies
11
Views
269

1,129,317
Messages
5,635,527
Members
416,862
Latest member
MGDlite

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back