On 2002-04-17 00:06, Phylis Sophical wrote:

Ian please excuse me for not making this more clear. Yes it was more than every other cell. I should know better. Part of the problem I find with Excel is trying to explain oneself as Excel is a language unto it's own. Here is a more detailed explanation:

This is a questionaire that has 6 questions and a possibility of 5 diffrent responses from Outstanding to Poor. B4,12,20,28,36,44 represent Outstanding for each of the 6 questions.

The other series, B9,17,25,33,41,49 represent the total amount of responses to each question. (All the Oustandings, Excellents, Goods, Okay's and Poor's combined)

I am trying to determine what percentage of the total responses are Outstanding. And so on with the others. So I take all the outstandings and devide that by the total number of responses to all 6 questions.

The formula I had, worked out fine except that if there is no value in the divisor cell, I get #DIV/0! in every cell I make this formula in. (1 formula cell for every Outstanding, Excellent, etc. times 12 months. That's 72 cells that I need this formula for a Summary of all questions. That's alot of #DIV/0!'s!!!!

I noticed that people do post their worksheets but this takes up an intire 8 1/2 X 14" sheet.

## Like this thread? Share it with others