Counting Two Characteristics from Two different Columns
I would be inclined to use a pivot table for this... Highlight the data that
you want to summarize including the headings. Select data - Pivot Table... |
You can just select Finish.
Drag the Account Rep field to the left column. Drag the Active / Inactive
Field next to the Account Rep in the left column. Now drage Active / Inactive
into the data area. That should do it... You can select an auto format to
make it look fancy. Alternativley the Active / Inactive could be dragged to
the upper row.
--
HTH...
Jim Thomlinson
"PGiessler" wrote:
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.
|