Home |
Search |
Today's Posts |
#1
|
|||
|
|||
counting text in a column
MD RN RT
y na na n y y y n na na y n I would like to total the Y and N from each column but ignore the NA Thank you for your help ferde |
#2
|
|||
|
|||
One way:
=SUM(COUNTIF(A1:A10,{"y","n"})) In article , "ferde" wrote: MD RN RT y na na n y y y n na na y n I would like to total the Y and N from each column but ignore the NA Thank you for your help ferde |
#3
|
|||
|
|||
Hi Assuming you column heading is in A1, paste this in an empty cell =COUNTIF(A2:A5,"Y")+COUNTIF(A2:A5,"N") Colin -- Colin Vicary ------------------------------------------------------------------------ Colin Vicary's Profile: http://www.excelforum.com/member.php...o&userid=10472 View this thread: http://www.excelforum.com/showthread...hreadid=395841 |
#4
|
|||
|
|||
ferde Wrote: MD RN RT y na na n y y y n na na y n I would like to total the Y and N from each column but ignore the NA Thank you for your help ferde Hi Ferde Assuming Header rows are in row 1, and data in a2:c5 To Count just the "Y"'s use =COUNTIF(A2:A5,"Y") in A6 and drag across to C6 To Count just the "N"'s use =COUNTIF(A2:A5,"N") in A6 and drag across to C6 And to count both use =COUNTIF(A2:A5,"Y")+COUNTIF(A2:A5,"N") in A6 and drag across to C6 Change ranges to suit your data Hope this helps Paul -- Paul Sheppard ------------------------------------------------------------------------ Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783 View this thread: http://www.excelforum.com/showthread...hreadid=395841 |
#5
|
|||
|
|||
Thank you so much , it works great
"Colin Vicary" wrote: Hi Assuming you column heading is in A1, paste this in an empty cell =COUNTIF(A2:A5,"Y")+COUNTIF(A2:A5,"N") Colin -- Colin Vicary ------------------------------------------------------------------------ Colin Vicary's Profile: http://www.excelforum.com/member.php...o&userid=10472 View this thread: http://www.excelforum.com/showthread...hreadid=395841 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
match and count words | Excel Worksheet Functions | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Counting every unique text string in a column | Excel Worksheet Functions |