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 :)

actually, i figured it out, thanks tho

"JMB" wrote:

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 :)

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

"JMB" wrote:

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 :)

Hi Scotty,

Try this

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

"ScottyC" wrote:

actually, i figured it out, thanks tho

"JMB" wrote:

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 :)

Glad to help.

"ScottyC" wrote:

actually, i figured it out, thanks tho

"JMB" wrote:

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 :)