| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditions in "countif"
Hi all, can you give a countif formula more than one condition/criteria, e.g. =countif(P:P,"female") and say for instance Blonde, how would I include the second criteria. I tried a number of ways =countif(P:P,"female";"blonde") , =countif(P:P,"female")+countif(P:P,"blonde") but nothing works. Cheers -- Clash ------------------------------------------------------------------------ Clash's Profile: http://www.excelforum.com/member.php...o&userid=18951 View this thread: http://www.excelforum.com/showthread...hreadid=507155 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| More than 3 Conditional Formatting Conditions | Excel Worksheet Functions | |||
| Vlookup with 3 or more conditions | Excel Worksheet Functions | |||
| Add cells from a range based on 2 conditions from 2 other ranges | Excel Worksheet Functions | |||
| SUM based on multiple conditions - SORRY, URGENT!!! | Excel Worksheet Functions | |||
| How to multiple conditions to validate more than 2 conditions to . | Excel Worksheet Functions | |||
Threaded Mode
