# IF question for multiple pages

1. ## IF question for multiple pages

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
clair_g@inbox.com

2. Hi clair_g, it would probably increase your number of views if you attached your sheet as compatible with previous excel versions.

3. Hi,

Try this in C20

``Please Login or Register  to view this content.``
This in C22

``Please Login or Register  to view this content.``
This in C24

``Please Login or Register  to view this content.``
Portuga - you may find this useful http://support.microsoft.com/kb/925180

4. Cool,

Thanks oldchippy

5. ## Thanks for the reply

Portuga, sorry, the file was too large to upload as a 2003 document.

oldchippy, thanks for the option, unfortunately it only seems to work if both of the referenced (green cells) on pages 1 and 2 are filled in with the same entry. I need it to be able to distinguish between all three options (1.25,1.5,1.75) and only include results from pages with the corresponding number.

thanks,

Greg

6. May be this in C20,

=IF('1'!I2=1.25,'1'!E19,0)+IF('2'!I2=1.25,'2'!E19,0)

Same in C22 and C24 adjust as necessary

7. ## Almost :)

Thanks oldchippy,
Your last solution is really close. I need it to average the results from the red cells. So if both green cells on pages one and two happen to be the same (1.25 etc.) than it will not add the red cells together but provide the average of the two. I tried to do it by changing your formula but I can't seem to make it work.

Thanks for all your help, if this works out it will save me and my coworkers hours and hours of time.

Greg

8. Hi,

=IF('1'!I2=1.25,'1'!E19,0)+IF('2'!I2=1.25,'2'!E19,0) /2

Divide by the number of pages you are refering to

9. Thanks,

I will give it a try.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1