In column c.....
In column c.....
=If(B2="Y",A2,0)
In column d.....
=If(B2="Y",1,0)
Then sum columns c and d.
Average is the division of the two sums.
Posted By: BeverlyHills0201 on June 13th 2005 at 17:11:32
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.