Super simple excel question

The other excel thread reminded me of a question I had in excel but never decided to figure out. I have this spreadsheet with a column title of: Seen/Not Seen and in the rows below it i have NS for not seen and S for seen. Its just a big ass list of NS and S in their own cells down the row in the same column. Now what I want to do is have excel total the N's and NS's so at the bottom it has Total NS: and Total S: My excel knowledge extends to the simple add/subtract/multiply type calculations.

Example of my spreadsheet:

Seen/Not Seen
NS
S
NS
NS
NS
S
S

Help

There is probably a better way to do it, but here is my idea.

in B2 put in this: =IF(A2="ns",1,0)
then drag it down to the bottom of the list. Then just =sum(B2,B???) and you'll have your total ns's. Do the same for the s's in the next column and that should pretty much cover it.

Assume your data is in cells A2 to A10, use the following formula: =COUNTIF(A2:A10, "NS"). Do the same for the S.

Thanks to both of you. I used the above method and it worked great. Blow jobs all around.

Is this for all your porn you haven't looked at?

you are on the right track but its actually to keep track of which of my movies (normal ones, not porno movies) i have seen.

the excel doc in question:

http://mrali.com/movies.xls

you have way too much time on your hands

if you want it to look a little cleaner you can have the totals in the column title. eg, replace D1 with this:

="S("&COUNTIF(D25000,"S")&") / NS("&COUNTIF(D25000,"NS")&")"

what the hell man, thats a great idea. looks much better now. thanks.