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, Jun 13, 17:11:32