Replies

Legare,

Thanks for your help. Attached is the file that I am working on. What I need is to develop a string that counts the number of occurrences of ‘N’ in the Ramp/Production column by meeting the criteria in both the QA Number column and Root Cause Column. I am currently using a string that sums based on two conditions. This is as follows:

=SUMPRODUCT((LEFT(‘ AllOpen ‘!A1:A995,6)=”200204″)*(LEFT(‘ AllOpen ‘!B1:B995,7)=”Support”)).

I thought by adding *(LEFT(‘ AllOpen ‘!C1:C995,1)=”N”) would work but it does not. Can you help! Thanks.

Legare,

Thanks for all of your help on getting this string to work. This is the string I eventually used.

SUMPRODUCT((LEFT(‘ AllClosed ‘!$A$1:$A$60,6)=”200206″)*(LEFT(‘ AllClosed ‘!$H$1:$H$60,4)=”TEST”))

But I now need to add another variable, in other use a 3rd column. Can you help. I tried to add the string but I am only getting the #N/A or Valid#.

Thanks.

Legare,

Thanks for all of your help. Now I need to get a string which pulls a result by utilizing 3 columns. I tried just adding another string but it did not work. Can you help. Thanks.

nstapleton

Legare,

Thanks for your help. Please look at the enclosed spreadsheet. What I want to do is to have the function look for the date string in Column A in the AllOpen Tab. The date string must use a wildcard so the format will be “200108*”. Then it will go to column B and look for a keyword such as “Test*” I must also utililize a wildcard here. The formula will count the number of occurences that these two criteria are meet. For this criteria, there are two that meet the criteria and ‘2’ will be returned to cell I3 in the Type spreadsheet. Thanks for your help. I hope this helps.

Thanks for your quick reply. I am using a wildcard in the formula (*). I have plugged in the formula and I am getting a result of 0. there are two rows that meet the criteria. Is there something I am doing wrong with the wildcard.
Thanks!