question on using countif or other function to count values in every other column

[sergiom920]

Guys i have a total coumn where i would like to do a count of the "Y"s in every other column.. How can i do that? see example below


Jan TY Jan LY FEB TY FEB LY MAR TY MAR LY
Product A Y Y N Y Y N


In this case the count of the Y should be 2, because JAN TY,and MAR TY have a Y

Please help..

 

[Andrew Poulsom]

A couple of possibilities:

=SUMPRODUCT(--(RIGHT(B1:G1,2)="TY"),--(B2:G2="Y"))
=COUNTIFS(B1:G1,"*TY",B2:G2,"Y")

The second formula requires Excel 2007 or above.

 

[Akashwani]

Hi,

Does this work?....

Excel Workbook
	A	B	C	D	E	F	G	H	I
1	Jan TY	Jan LY	Feb TY	Feb LY	Mar TY	Mar LY		Y
2	Y	Y	N	Y	Y	N		2
3
Sheet5

The above formula was taken from here.....

ExcelBanter - View Single Post - CountIf using every other column

I hope that helps.

Ak