E
EyeNoNothing via OfficeKB.com
Hi,
Have probably another dumb question, but the information that you guys gave
me from my last question really helped out, so here is another one, and I'll
try to be as detailed as possible.
On Sheet 1, I want to create a summary page, which will tally up Sheets 2
through say Sheet 10. Sheets 2-10 Is where I have all my data.
One each of these Data Sheets, I have 1 cell that is dedicated to assigning
the page a property, such as difficulty, Easy, Normal, and Difficult. One
each of these sheets, there is also 1 cell that is dedicated for a number.
Example.
Sheet 1
C1 = Easy, C3 = 92.6
Sheet 2
C1 = Difficult, C3 = 52.8
Question:
On this summary page that I have created, is there a way to assign specific
cells to display averages for each of the difficulty ranges.
On Summary Page
C1 = Searches an all the sheets in the workbook for the Easy tag in C1, and
will count up how many pages existed.
C4 = Searches all the Sheets for the Easy tag in C1, and will average the
numbers in these sheets from C3.
Example:
On Sheet 2, C1=Easy and C3=100
One Sheet5, C1=Easy and C3=72
One Sheet7, C1=Easy and C3=52
End Result on Summary page:
Number of Sheets set that were Easy: 3
Average From these sheets are: 74.6
Now, I'm flexiable as to the Tags for the difficulty setting, if I can use
text that would be great, but if I have to give it a numberical value to do
this, that would be easy as well.
Any help would really help me out.
Thanks
Have probably another dumb question, but the information that you guys gave
me from my last question really helped out, so here is another one, and I'll
try to be as detailed as possible.
On Sheet 1, I want to create a summary page, which will tally up Sheets 2
through say Sheet 10. Sheets 2-10 Is where I have all my data.
One each of these Data Sheets, I have 1 cell that is dedicated to assigning
the page a property, such as difficulty, Easy, Normal, and Difficult. One
each of these sheets, there is also 1 cell that is dedicated for a number.
Example.
Sheet 1
C1 = Easy, C3 = 92.6
Sheet 2
C1 = Difficult, C3 = 52.8
Question:
On this summary page that I have created, is there a way to assign specific
cells to display averages for each of the difficulty ranges.
On Summary Page
C1 = Searches an all the sheets in the workbook for the Easy tag in C1, and
will count up how many pages existed.
C4 = Searches all the Sheets for the Easy tag in C1, and will average the
numbers in these sheets from C3.
Example:
On Sheet 2, C1=Easy and C3=100
One Sheet5, C1=Easy and C3=72
One Sheet7, C1=Easy and C3=52
End Result on Summary page:
Number of Sheets set that were Easy: 3
Average From these sheets are: 74.6
Now, I'm flexiable as to the Tags for the difficulty setting, if I can use
text that would be great, but if I have to give it a numberical value to do
this, that would be easy as well.
Any help would really help me out.
Thanks