Hi Ed.

One more question. As I mentioned before, I figured out how to do it
across columns. The last thing I need to do is to fundamentally do the same
thing, but across both rows and columns as a total % for the entire field
(d12:g31). I have been playing around trying to figure it out and can't :(

Thanks in advance



"Ed Ferrero" wrote:

Hi cionnaith,

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.

First Cell function, No of variables entered
=COUNT(D12:D31)

Second cell function, Total calculated percentage
=SUM(IF(ISBLANK(D12:D31),0,(D12:D31+1)/5))/ROWS(D12:D31)

This is entered as an array function, i.e. enter this in a cell then press
Ctrl-Shift-Enter
You have done it right when the formula is surounded by curly brackets
{=SUM(IF(ISBLANK(D12:D31),0,(D12:D31+1)/5))/ROWS(D12:D31)}

Ed Ferrero
www.edferrero.com


.