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, Jun 13, 16:57:07