Hello,

Any help would be greatly appreciated.

I'm trying to count the number of occurences of a number in on column and then a y or n in the second column relating to that number. IE Column A has as series of numbers that run from 1 to 4. Column B has either a Y or N.

Example: Column A has 1 in cell one and Column B has Y in cell one and I'm trying to count the number of times this happens in the column.

I have tried a bunch of different things, countif, sumif, Dcount A, sumproduct, etc. and none of them seem to work. Any ideas?

Thank you for your help!

Have a great day.