Hi Excel Forum,

I am using the formula below to look at a number of ranges and return the total number of Y values for Female students in the column with english in the title.

=SUMPRODUCT(--('GCSE Entries'!$I$2:$W$31="Y"),('GCSE Entries'!$E$2:$E$31="F")*ISNUMBER(FIND("English",'GCSE Entries'!$I$1:$W$1)))
I was wondering if it was possible to adapt this formula so it looked for more than just a Y in range I2 to W31, for example if it could look for values Y,2,A*

Basically in short terms i would like the formula to look for more values then just Y in that range, is this possible?

I look forward to your help!