Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Different font characteristics in concatenated cell | Excel Worksheet Functions | |||
How do I make all worksheets inherit certain characteristics | Excel Worksheet Functions | |||
Spreadsheet says CorruptedCompressedFile characteristics | Excel Discussion (Misc queries) | |||
Geometric Characteristics Symbols | Excel Discussion (Misc queries) | |||
Changing Font Characteristics Within a Formula | Excel Discussion (Misc queries) |