Hi. Here's an example table below and the column I'm trying to count and calculate. Looking for some help...
[TABLE="width: 500"]
<tbody>[TR]
[TD]
[/TD]
[TD="align: center"]A
[/TD]
[TD="align: center"]B
[/TD]
[TD="align: center"]C
[/TD]
[TD="align: center"]D
[/TD]
[TD="align: center"]E
[/TD]
[TD="align: center"]F
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Number of A Modules
[/TD]
[TD]Number of B Modules
[/TD]
[TD]Number of C Modules
[/TD]
[TD]Number of D Modules
[/TD]
[TD]Number of E Modules
[/TD]
[TD]% of Penetration of all Modules
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]550
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD="align: center"]?
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]3
[/TD]
[TD]40
[/TD]
[TD]355
[/TD]
[TD]351
[/TD]
[TD]5312
[/TD]
[TD="align: center"]?
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD="align: center"]?
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]-
[/TD]
[TD]30
[/TD]
[TD]525
[/TD]
[TD]165
[/TD]
[TD]33
[/TD]
[TD="align: center"]?
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]355
[/TD]
[TD]-
[/TD]
[TD]34
[/TD]
[TD="align: center"]?
[/TD]
[/TR]
</tbody>[/TABLE]
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?
[TABLE="width: 500"]
<tbody>[TR]
[TD]
[/TD]
[TD="align: center"]A
[/TD]
[TD="align: center"]B
[/TD]
[TD="align: center"]C
[/TD]
[TD="align: center"]D
[/TD]
[TD="align: center"]E
[/TD]
[TD="align: center"]F
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Number of A Modules
[/TD]
[TD]Number of B Modules
[/TD]
[TD]Number of C Modules
[/TD]
[TD]Number of D Modules
[/TD]
[TD]Number of E Modules
[/TD]
[TD]% of Penetration of all Modules
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]550
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD="align: center"]?
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]3
[/TD]
[TD]40
[/TD]
[TD]355
[/TD]
[TD]351
[/TD]
[TD]5312
[/TD]
[TD="align: center"]?
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD="align: center"]?
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]-
[/TD]
[TD]30
[/TD]
[TD]525
[/TD]
[TD]165
[/TD]
[TD]33
[/TD]
[TD="align: center"]?
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]-
[/TD]
[TD]-
[/TD]
[TD]355
[/TD]
[TD]-
[/TD]
[TD]34
[/TD]
[TD="align: center"]?
[/TD]
[/TR]
</tbody>[/TABLE]
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?