Counting the number of "Y" in a row

  • Thread starter Thread starter Mikey C
  • Start date Start date
M

Mikey C

Hi all

I know this has to be pretty simple but I can't quite figure it out. I
want a field at the end of each row which will count the number of
fields with a "Y" and show the total number. I tried an IF statement
but this went all wrong and I have tried the COUNT () statement but
was not sure how to get this to count letters.

Can somebody please help?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA - counting cells by colors and names to it in two different rows. 0
Need to count cells in Column1 where each cell's row also hasspecified value in Column2 1
Need to count no. of rows where cell in column A = "value1" AND cellin column B (same row) = "value2 2
Count in a range of numbers 8
Pivot table calculated field Count(field) / sum(field) 0
SUMIFS ONLY UNTIL the number REPEATS 1
Count number of changes in a row 1
Countif, index and match 2

Back
Top