T
tim123-321
Hello,
First of all I am extremely new to excel. I used it some 7 years ago
and was just given a project in which I must use it again.
I have a workbook that contains many seperate but dependent forms. My
issue is that I have to have data from one form be comparable with data
from the other. The numerical data from the option forms needs to be
summerized on the summary page. In addition, I need to have an
analysis of the numerical data based upon only those fields that
contain data.
In other words, I need to summerize or obtain an average value for
those fields that contain numerical data. Some fields may not contain
data depending on the needs of the user.
I know this is cryptic at best but I don't know anyother way to explain
it. I have included the file for your analysis.
Thank you for your help.
Sincerely,
Tim
Attachment filename: assessment workbook_v01.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=416226
First of all I am extremely new to excel. I used it some 7 years ago
and was just given a project in which I must use it again.
I have a workbook that contains many seperate but dependent forms. My
issue is that I have to have data from one form be comparable with data
from the other. The numerical data from the option forms needs to be
summerized on the summary page. In addition, I need to have an
analysis of the numerical data based upon only those fields that
contain data.
In other words, I need to summerize or obtain an average value for
those fields that contain numerical data. Some fields may not contain
data depending on the needs of the user.
I know this is cryptic at best but I don't know anyother way to explain
it. I have included the file for your analysis.
Thank you for your help.
Sincerely,
Tim
Attachment filename: assessment workbook_v01.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=416226