I have 2 sets of data.   I want to countif the letter in the column on workbook 2  = L but I only want to count it if it relates to column A of worksheet 1.  Can I combine a Countif & Vlookup to achieve this?

Hi GemT91,

I suggest you provide a sample file and be a bit more precise to explain your requirement.

You can send the sample file to our email address:
ibsofc@microsoft.com 

Please Note: Please add the URL of the case in the email subject or body.

I'm glad to help and follow up your reply.

Regards,

Emi Zhang
TechNet Community Su

Not sure how you determine how "it relates to column A of worksheet 1."  But you could consider adding a column to Workbook2 with a formula that checks the relationship to Workbook1 and evaluates to either TRUE or FALSE.  Then AND that result with the letter in question.  For example, the new column could contain a formula similar to this:  =AND(<however you evaluate the relationship>=TRUE,<Letter>="X")

Then write your countif formula to count rows where the value in the new column is TRUE.  You can hide the new column if you don't like the way it makes the sheet look.

Hope that helps.

cw