Hi. Here's an example table below and the column I'm trying to count and calculate. Looking for some help...
<tbody>
</tbody>
There are various numbers across each cell from A1:E5. However, what I would like to do is figure out what equation I can put in cells F1:F5 that can just calculate a % off of whether or not each column is filled in across columns A to columns E. What I mean is, in cell F1 the answer should be 20% since there's one column filled in out of the five across row 1. For F2, it should be 100% since all five columns have a number in it out of the five possibilities. Cell F3 should be 0% since nothing is filled in across all five columns. Cell F4 should be 80% since all columns across row 4 are filled in excel column A. Cell F5 should be 40% since columns "Number of C Modules" and "Number of E Modules" are filled in.
I tried starting it out by creating nested IF and IFBLANK statements but soon lost track as I have to write several dozens to track all the possibilities (I think around 32 possibilities) which is nuts. There's got to be an easier way. Any help?
A | B | C | D | E | F | |
Number of A Modules | Number of B Modules | Number of C Modules | Number of D Modules | Number of E Modules | % of Penetration of all Modules | |
1 | 550 | - | - | - | - | ? |
2 | 3 | 40 | 355 | 351 | 5312 | ? |
3 | - | - | - | - | - | ? |
4 | - | 30 | 525 | 165 | 33 | ? |
5 | - | - | 355 | - | 34 | ? |
<tbody>
</tbody>
There are various numbers across each cell from A1:E5. However, what I would like to do is figure out what equation I can put in cells F1:F5 that can just calculate a % off of whether or not each column is filled in across columns A to columns E. What I mean is, in cell F1 the answer should be 20% since there's one column filled in out of the five across row 1. For F2, it should be 100% since all five columns have a number in it out of the five possibilities. Cell F3 should be 0% since nothing is filled in across all five columns. Cell F4 should be 80% since all columns across row 4 are filled in excel column A. Cell F5 should be 40% since columns "Number of C Modules" and "Number of E Modules" are filled in.
I tried starting it out by creating nested IF and IFBLANK statements but soon lost track as I have to write several dozens to track all the possibilities (I think around 32 possibilities) which is nuts. There's got to be an easier way. Any help?