count the # of times "name" is in E and "x" in F are in the same r
 

Not exactly sure how to describe it best. Just need a tally of the times a
two different names in two different columns are on the same row. Thanks!

count the # of times "name" is in E and "x" in F are in the same r
 

Try something like this...

=SUMPRODUCT(--(A2:A10="Biff"),--(B2:B10="Betty"))

Better to use cells to hold the criteria.

D2 = Biff
E2 = Betty

=SUMPRODUCT(--(A2:A10=D2),--(B2:B10=E2))

If you happen to be using Excel 2007:

=COUNTIFS(A2:A10,D2,B2:B10,E2)

--
Biff
Microsoft Excel MVP


"Nielly" wrote in message
...
Not exactly sure how to describe it best. Just need a tally of the times
a
two different names in two different columns are on the same row. Thanks!

count the # of times "name" is in E and "x" in F are in the same r
 

Hi,

In 2007:

=COUNTIFS(E1:E9,"Shane",F1:F9,"x")

or if the name is in A1

=COUNTIFS(E1:E9,A1,F1:F9,"x")


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Nielly" wrote:

Not exactly sure how to describe it best. Just need a tally of the times a
two different names in two different columns are on the same row. Thanks!