View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
pgiessler pgiessler is offline
external usenet poster
 
Posts: 17
Default Counting Two Characteristics from Two different Columns

I have a spreadsheet that lists Account Rep names in Column "A", Client Names
in Column "B" and client status in Column "C" (i.e. active or inactive)

Bob | Medco | Active
Tim | Johnson | Inactive
Tim | P-Products| Active
Jill | Kaystar | Active
Tim | Gemni | Active
Bob | Transcorp | Inactive

At the top of the Spreadsheet I want to tally the information to indicate that
Tim has three clients, 2 Active Client and 1 Inactive client

I believe I have done this before, but cannot for the life of me remember
what I did - I have tried to do a SUMPRODUCT but keep getting a zero result
so something is amiss in my formula.

Help would be much appreciated.