Lookup a row and count all the "Yes" values across multiple columns

jimmbo

I can do both of these functions separately without issue, but am struggling to combine them.

I have 2 sheets and would like to lookup a value from the 1st sheet on the 2nd sheet, and then return all the "yes" fields on that row from a set of 8 columns.

I can use match to lookup the value from the 1st sheet and find it in the 2nd sheet.

I can use countif to return how many "yes" values there are across the 8 columns for a specific row.

But how can i combine match with countif? I keep getting incorrect argument.

Any thoughts on this?

Thanks.

KPH

Hi @jimmbo

Can you add a column to the second sheet and put the COUNTIF in there and then return the value of that column in an INDEX MATCH, matching on the lookup value?

jimmbo

I could certainly do that if necessary, but I was hopeful to do it within 1 function and not require the additional column.