Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Worksheets
Which (logical) function?
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="JustJill, post: 3865345"] Table was codes...if the ID begins with a w and the number in the second column is a 1 add the ones (which are male ;) A B 1 ID Gender 2 W01 2 3 W02 1 4 G01 1 5 W08 1 I have: =COUNTIF(A$2:$A$5,"=w??")*AND(COUNTIF(B$2:$B$5,"1"))...which isn't correct because it returns 3 (all the w's) I suppose. What do I do??? TIA! [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Worksheets
Which (logical) function?
Top
