How to sum Diffrrent Alphabets or specific words

zabee

New Member
Joined
May 12, 2010
Messages
4
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")
 

Some videos you may like

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

Watch MrExcel Video

Forum statistics

Threads
1,118,569
Messages
5,572,979
Members
412,491
Latest member
tweetytoon
Top