countif

[ScottyC]

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

 

[ScottyC]

actually, i figured it out, thanks tho

Say the data is in A1:B6

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

 

[ScottyC]

Thanks, that worked. however, I can't seem to get that formula to work across
diffreent pages within the database?

 

[Srik]

Hi Scotty,

Try this

=COUNTIF('[Workbook] Sheet!$A$2:$A$2530,A2)

 

[JMB]

Glad to help.

actually, i figured it out, thanks tho