Adapting Sumproduct Formula

[Jamidd1]

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.

Please Login or Register  to view this content.

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!

[protonLeah]

(How to) Upload a Workbook directly to the Forum
(please do not post pictures or links to worksheets)

• Click Advanced next to Quick Post button at the bottom right of the editor box.
• Scroll down until you see "Manage Attachments",
• Click the "Choose" button at the upper left (upload from your computer).
• Select your file, click "open", click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Close the Attachment Manager window.
• Click "Submit Reply"

Note: Please do not attach password protected workbooks/worksheets
Ensure to disable any Workbook Open/Autorun macros before attaching!