Countifs with conditions based on same row in source

[ritmo2k]

I have a large data set where one requirement is to obtain the count of duplicate people using their first and last name provided in two discrete columns and perform a lookup in another sheet for a count of that sheets rows that have the same two values in two different rows.

For example, in the attached document, A2:B13 represents the lookup data I want to check for appearances of rows in E2:F10.
A matching row must have both the first and last name equal, then I want the count in column next to E2:F10.

I know I could create a computed column in each concatenating the first and last name of each sheet to simplify this, but in this case it would more efficient to create a single formula and auto fill it throughout a column.

Is this possible?

[Richard Buttrey]

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.
It's not obvious to me what result you actually want.

Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.

[ritmo2k]

Hi Richard,
Thanks for the suggestion, I have uploaded a sample document and updated the post.

[JeteMc]

Try pasting the following into cell H2 and copying down: =SUMPRODUCT(--(A$2:A$13&B$2:B$13=E2&F2))
Let us know if you have any questions.