Hi,
I have a worksheet which i want to use a countif function (i think!?) where i can look at 2 different columns of data and only count if in these columns a particular word is said. e.g.
column A has a list of region numbers and column I has an assessment result. I just want to do a count so that if column A has the number 102 in it and Column I has the word PASS in it then count this as 1.
this is what I am using at the moment, although this just counts the total of both:
=COUNTIF('Retirement Options - Combined'!A2:A599,"*101*")+COUNTIF('Retirement Options - Combined'!I2:I599,"*PASS*")
this is probably really easy but am struggling somewhat here.
many thanks
Ashley
Bookmarks