ExcelBanter - countif

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

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

- - countif (https://www.excelbanter.com/excel-worksheet-functions/79667-re-countif.html)

JMB

countif

Say the data is in A1:B6

=SUMPRODUCT(--(A1:A6="A"),--(B1:B6="A"))

"ScottyC" wrote:

Hi

i am trying to get Excel to tell me the number of times a value appears in
both column a and columb b. for example:

a a
a n
a a
m a
a a
m d

the result i am looking for excel to come up with is 3.

i have been trying for about 3 days now with no luck

does anyone have suggestions?

Thanks :)

All times are GMT +1. The time now is 03:13 PM.