Combining IF and COUNTIF functions

Hello,

I'm hoping that someone can help me figure this out.

I would like to create a formula that would allow me to count the number of entries in a column that meet the criteria set forth in a previous column.

Column A - contains Y or N
Column B - contains Y or N

I want to count the number of entries in Column B that = Y only if Column A = Y

Or...if column A = Y, how many in column B = Y

Any assistance is appreciated

Not exactly sure what you want here but assuming you have only one entry in column A then;

=IF(ColumnACellWithData="Y", COUNTIF(B:B,"Y"), IF(ColumnACellWithData="N", COUNTIF(B:B,"N"),"Column A entry Invalid"))

Originally Posted by sweep

Hi,

This should work for you

=SUMPRODUCT((A1:A100="Y")*(B1:B100="Y"))

Adjust ranges as required.

Sweep,
This worked perfectly - thank you!