I am uploading a copy of the workbook that I am working on so that it is
clear what I am talking about. I have set up a tool for my patients
where they can log a numerical rating by symptom, by day and see an
average of how they are responding to each symptom at the end of the
month and with symptoms overall each day. I want to provide an average
of all symptoms at the end of the month. You will notice on the
workbook that the dates are across the top and the symptoms are down the
side. The formula for the daily average of all symptoms is
=AVERAGE(B5:B34) and it works fine. The formula to average each symptom
as numerical values are entered through the end of the month is
=AVERAGE(B5:AF5) and it works fine. Problem is that when I enter
=AVERAGE(AG5:AG34) it is accepted as a formula and shows up as ## in the
orange cell, however when I enter data in the workbook this cell does
not display a numerical value. I know it is a average of averages,
however, it wouldn't matter. I am merely telling it to average a column
of numerical values, aren't I. What am I missing. A fellow in another
group gave me a formula that I tried without success. I am a newbie and
just wanting to make this work!! Can anyone help? What formula needs
to go into AG36 to make this work??