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!