Is there any way to meld these two together? I have a column with our sales
people's initials in them, and another column with the status of their
projects:
Column D Column F
AA neu
BB eng
AB s
AC eng

I want to sum the info so we can see how many of AA's job statuses are "eng"

so I want it to count the number of times the status in column F is "eng"
but only if the "eng" is the same row as "AA"'s initials in column D.

TIA!

With
A1: (the initials to find....eg ABC)
A2: (the status to count....eg Done)

This formula counts the projects with that status for the
person with those initials:
A3: =SUMPRODUCT((D2:D1000=A1)*(F2:F1000=A2))

Is that something you can work with?
Post back if you have more questions.

Regards,

Ron
Microsoft MVP - Excel

"IMS Lori" wrote in message
...
Is there any way to meld these two together? I have a column with our
sales
people's initials in them, and another column with the status of their
projects:
Column D Column F
AA neu
BB eng
AB s
AC eng

I want to sum the info so we can see how many of AA's job statuses are
"eng"

so I want it to count the number of times the status in column F is "eng"
but only if the "eng" is the same row as "AA"'s initials in column D.

TIA!

On Mon, 2 Jun 2008 13:49:00 -0700, IMS Lori
wrote:

Is there any way to meld these two together? I have a column with our sales
people's initials in them, and another column with the status of their
projects:
Column D Column F
AA neu
BB eng
AB s
AC eng

I want to sum the info so we can see how many of AA's job statuses are "eng"

so I want it to count the number of times the status in column F is "eng"
but only if the "eng" is the same row as "AA"'s initials in column D.

TIA!


Try the SUMPRODUCT formula for this.

=SUMPRODUCT((D1:D1000="AA")*(F1:F1000="eng"))

change 1 and 1000 so that your data is covered

Hope this helps. / Lars-Åke

Thanks so much! Worked like a charm!

"Lars-Ã…ke Aspelin" wrote:

On Mon, 2 Jun 2008 13:49:00 -0700, IMS Lori
wrote:

Is there any way to meld these two together? I have a column with our sales
people's initials in them, and another column with the status of their
projects:
Column D Column F
AA neu
BB eng
AB s
AC eng

I want to sum the info so we can see how many of AA's job statuses are "eng"

so I want it to count the number of times the status in column F is "eng"
but only if the "eng" is the same row as "AA"'s initials in column D.

TIA!


Try the SUMPRODUCT formula for this.

=SUMPRODUCT((D1:D1000="AA")*(F1:F1000="eng"))

change 1 and 1000 so that your data is covered

Hope this helps. / Lars-Ã…ke

Try this:

=SUMPRODUCT(--(D1:D10="AA"),--(F1:F10="eng"))

HTH,
Paul

--

"IMS Lori" wrote in message
...
Is there any way to meld these two together? I have a column with our
sales
people's initials in them, and another column with the status of their
projects:
Column D Column F
AA neu
BB eng
AB s
AC eng

I want to sum the info so we can see how many of AA's job statuses are
"eng"

so I want it to count the number of times the status in column F is "eng"
but only if the "eng" is the same row as "AA"'s initials in column D.

TIA!