COUNTIF AND

  • Thread starter Thread starter IMS Lori
  • Start date Start date
I

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!
 
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
 
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!
Click to expand...


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 said:
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
Click to expand...
 
Back
Top