Hi. I have run into a snag trying to figure out how to make one of my cells
calculate the way I need it to. Here is the rundown: I have a column of data
that needs to have only 0,1,2,3, or 4 entered in each cell. These values
actually represent qualitative data. At the end of the column I need to count
how many variable values were entered across 20 cells (e.g. 10 out of 20, or
all 20). The syntax for that function I used is =COUNTIF(D12:D31,"=0"),
which works. Now the area that I am having trouble is that I need another
cell that will calculate the total percentage for the column based on those
0,1,2,3, or 4 entries in the column. I previously used 1, 2, 3 or 4 as the
variable entries and all was well with this syntax to calculate the
percentage =SUM(D12:D31)/(D32*4). Now that I have had to use "0" as a
variable value, I can't get the cell to count it among the rest of the
entries to calculate the percentage. Given that I now have 5 variable
entries, I tried changing the *4 to *5, but the "0's" are not being counted.
In short, what I need to happen is if all of the entries in the column of 20
cells are 0's the first cell function I described should result in the number
20. Then I need the total calculated percentage in the other cell to be 20%
for all 0's. It would be 40% if all 1's, 60% if all 2's, 80% if all 3's and
100% if all 4's. I hope this makes sense.