Hi,
Hopefully this makes sense. I have a document that has lots of pages, the attached only has 3. The first is a summary which requires averages from cells on the other pages. Highlighted in green on the summary page are three different numbers each page could apply to (each subsequent page has a green cell that could be any one of the three values).
Each page has multiple data entries (only one will be used for this question for simplicity). Highlighted in red is the number I need.
Here is the tricky part, on the two pages (labeled 1,2) If the green cell = 1.25mm I need the average of the red cells on all sheets where the green cell equals 1.25mm to be in the appropriate red box on the summary page.
However, the number in the green cell could be 1.50mm and I would need the average of the red cells on all pages where the green cell equals 1.50mm, and the same if the green cell equals 1.75mm.
I hope this makes sense and is possible. Any assistance would be greatly appreciated, even if it is to say I can't do what I am trying to do
Greg
[email protected]
Bookmarks