ExcelBanter - COUNTIF or COUNT.... IF

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - COUNTIF or COUNT.... IF (https://www.excelbanter.com/excel-worksheet-functions/189007-countif-count-if.html)

MBS

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

Teethless mama

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

Marcelo

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

All times are GMT +1. The time now is 02:14 AM.