Thread: COUNTIF AND
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
IMS Lori IMS Lori is offline
external usenet poster
 
Posts: 10
Default COUNTIF AND

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!