Close :)

I basically need to nest that. I want to COUNTIF on one column in the row
and then COUNTIF on another column with ONLY the rows that matched the first
COUNTIF. I tried using AND but wasn't able to get it to give me a number
value, I could only get it to output a TRUE value.

Formula that outputs TRUE looks like this:

=AND(COUNTIF('Details - Nov'!J:J,"Fred"),COUNTIF('Details -
Nov'!L:L,"Service"))

Kat

"Peo Sjoblom" wrote:

=COUNTIF(Column,"text")

Regards,

Peo Sjoblom

"katgolightly" wrote:

I have rows of data and I would like to search by one column, if the text
matches, I'd like to then search only those matching rows by the text in a
second column. I only need the count of matches.