Just a simple question guys, I can seem to figure it out.

In excel.

I have 2 different columns, Column A with numbers ex. 1,20,45 etc. and Column B with words, adhesive, abrasive etc. Each row is independent.

I'm trying to count Columns A only if they have a "1" only if column B has "adhesive"

any ideas? I have tried countif, if, sumproduct and I could not get it.

try adding a third column to thurn adhesive into a number

thats the easy way out but thanks

If you're trying to count the number of records you have that meet a criteria in column A (1) AND a criteria in column B ("Adhesive") you could use countifs