G

#### Guest

I work in mental health research and my department collects information from

patients by interviews and questionnaires. The paper and pencil

questionnaires are filled in by patients and then one of our staff members

enters the raw data into EXCEL 2002 (for this application I was in a hurry

otherwise I would have set it up in ACCESS) so that scores can be computed

and the data analyzed.

My task: to have EXCEL compute scores (say Depression scores) as the raw

data is entered.

What I did:

I opened a workbook, and set up two worksheets within.

The first worksheet is for raw data and the columns correspond to the items

on the questionnaire.

The second worksheet is where the scoring takes place. One formula

references ten columns from the raw data worksheet and asks for a sum.

Another formula references five other columns from the raw data worksheet and

asks for an average.

Once the formulas were completed and set up in a row , I then copied these

formulas down the worksheet to row 500 or so. I didn't know how many

patients were going to be interviewed but 500 seemed like a good guess.

The problem:

As I copy my formulas down the worksheet, zeros appear automatically because

of course EXCEL is calculating, as it should. The problem is that I don't

want EXCEL to calculate NULL cells--zeros have meaning in our questionnaires

and so an automatic zero result is throwing off our scoring because we think

it's from raw data but really it's from empty cells.

Wish:

I would like to prevent EXCEL from carrying out my formulas based on empty

cells and instead provide a score if it encounters a zero or other number.

Kindly help me.

Thanking you in advance for your consideration of this issue,

Myriam