View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Karpo Karpo is offline
external usenet poster
 
Posts: 3
Default Filtering without Filter

I just don't get the following. Any ideas?

"A" row I have two different values I use: "Contact" and "Not a contact".
"B" row I have the person's name (employee).
"C" row I have a quantity, just one number.

Now what I need is to output quantities of how many Contacts Employee1 or
Employee2 or Employee3 have.
Also what I need is to get the number of contacts - which can be found on
row "C".

Should I use COUNT.IF ? Row A can have 2 or more different values so should
there be somekind of conditional IF function included?

This is going to be a self-updating excel in the end that will show "Live",
who has the most contacts. I understand that using Auto-filter would easily
give me answers, but I'm afraid it's not an option if this is going to be one
big shared excel with pretty graphs.