Z zabee New Member Joined May 12, 2010 Messages 4 May 12, 2010 #1 If below mentioned cells contains a2=Y or yes a3=Y or yes a4=N or No a5=Y or yes a6=N or No a7=Y or yes a8=N or No In a9 cell (how can i sum how many times in above cells(a2:a8) it was "Y" and how many times it was "N")
If below mentioned cells contains a2=Y or yes a3=Y or yes a4=N or No a5=Y or yes a6=N or No a7=Y or yes a8=N or No In a9 cell (how can i sum how many times in above cells(a2:a8) it was "Y" and how many times it was "N")
S snowblizz Well-known Member Joined Mar 16, 2009 Messages 1,123 May 12, 2010 #2 =countif(A2:A8,"N") =countif(A2:A8,"Y")
Z zabee New Member Joined May 12, 2010 Messages 4 May 12, 2010 #3 @ Thanks Snow I was badly trapped..It solved my problem