I am setting up a spread sheet that is a list of behaviors over a period of time. If the behavior occurs I put an "x" in the cell for the behavior and the time. I am trying to total the "x's" in a separate cell, but can't figure out the formula needed to "count the "x's" to give me back a numeric value. Help!!
assuming your data is in column A, put this where you need the total...
=COUNTIF(a3:a10,"x") adjust range as needed
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks