COUNTIF AND

[IMS Lori]

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!

 

[Ron Coderre]

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((D21000=A1)*(F2:F1000=A2))

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

Regards,

Ron
Microsoft MVP - Excel

 

[Lars-Åke Aspelin]

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((D11000="AA")*(F1:F1000="eng"))

change 1 and 1000 so that your data is covered

Hope this helps. / Lars-Åke

 

[PCLIVE]

Try this:

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

HTH,
Paul

 

[IMS Lori]

Thanks so much! Worked like a charm!

Try the SUMPRODUCT formula for this.

=SUMPRODUCT((D11000="AA")*(F1:F1000="eng"))

change 1 and 1000 so that your data is covered

Hope this helps. / Lars-Ã…ke