Another Excel formula question...
I have two columns of data - Column A containing a premium level (in ?), and Column B which asks for a response received - either a 'y' or an 'n'
I am trying to write a formula for the average premium level in Coumn A, but only when Column B contains a 'y'.
How do i get it to only pick out the values in Column A (and do the relevant averaging), if the column next to it has a 'y' in it?
Help!!!
Posted By: Yellalee on June 13th 2005 at 16:57:07
Message Thread
- Another Excel formula question... (General Chat) - Yellalee, Jun 13, 16:57:07
- You need a macro init. (n/m) (General Chat) - Rivers_Wonderland, Jun 13, 17:02:26
- Yeah but written how? (n/m) (General Chat) - Yellalee, Jun 13, 17:07:40
- In column c..... (General Chat) - BeverlyHills0201, Jun 13, 17:11:32
- ...is the correct answer! Blinding, thanks! (n/m) (General Chat) - Yellalee, Jun 13, 17:17:37
- In column c..... (General Chat) - BeverlyHills0201, Jun 13, 17:11:32
- Yeah but written how? (n/m) (General Chat) - Yellalee, Jun 13, 17:07:40
- You need a macro init. (n/m) (General Chat) - Rivers_Wonderland, Jun 13, 17:02:26
Reply to Message
In order to add a post to the WotB Message Board you must be a registered WotB user.
If you are not yet registered then please visit the registration page. You should ensure that their browser is setup to accept cookies.