| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF or COUNT.... IF
Working on Sheet 2, I need to count records from Sheet1 but only want if ColA
= "text1" and ColB = "text2". COUNTIF(('Sheet1'!A1:A10,"text1")*('Sheet1'!B1:B10 ,"text2")) This is the formula I have been playing with that obviously is not working! -- MBS |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Please help with Count or Countif... | Excel Discussion (Misc queries) | |||
| how can I count (countif) the character: * | Excel Worksheet Functions | |||
| count many with COUNTIF? | Excel Worksheet Functions | |||
| Count, Countif, Sumif?? | Excel Worksheet Functions | |||
| COUNTIF-how do I count the quantity of 'H', as opposed to 'h'? | Excel Worksheet Functions | |||
Threaded Mode
