| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Which (logical) function?
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Logical function please | Excel Worksheet Functions | |||
| Logical Function | Excel Worksheet Functions | |||
| Help!!! - logical function for someone not very logical | Excel Worksheet Functions | |||
| Help with logical function | Excel Worksheet Functions | |||
| should it be if() or another logical function? | Excel Worksheet Functions | |||
Threaded Mode
