| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
COUNTIF or COUNT.... IF
=SUMPRODUCT(--('Sheet1'!A1:A10,"text1"),--('Sheet1'!B1:B10,"text2"))
"MBS" wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
COUNTIF or COUNT.... IF
=sumproduct(--(sheet1!a1:a10="text1")*(sheet1!b1:b10="text2"))
hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "MBS" escreveu: 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 |
| Reply |
| 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 | |||
Hybrid Mode
