Totaling Column Question

[jbyrne]

I have employee initials in Col B
In column D I have text consisting of either TR or TO.
In Column E, I have text: containing YES or No.

I want on a seperate sheet to total the number of TO'S and TR'S for each employee.
Also give a percentage of the number of TO YES'S and the percentage of TR YES'S.

Any help would be appreciated

[eliW]

On 2002-04-17 08:54, jbyrne wrote:
I have employee initials in Col B
In column D I have text consisting of either TR or TO.
In Column E, I have text: containing YES or No.

I want on a seperate sheet to total the number of TO'S and TR'S for each employee.
Also give a percentage of the number of TO YES'S and the percentage of TR YES'S.

Any help would be appreciated

Jbyrne,

You can use here two separate pivot tables: In one you put the employee name in rows, TR/TO in column and then count them in DATA.

In the sconed you do the same for TR/TO and Yes/No, and then calculate percentage from the table.

Eli

[Al Chara]

Not knowing what your sheets are called, I setup the following formulas to go on the same sheet as your data. Edit as needed.

Cell E1:
=SUMPRODUCT(($B$1:$B$6="AB")*($C$1:$C$6="TR"))
This will count the number of TR's for initials AB

Cell F1 (formatted as percent):
=SUMPRODUCT(($B$1:$B$6="AB")*($C$1:$C$6="TR")*($D$1:$D$6="YES"))/E1
This will calculate the percentage of TR's that have YES for initials AB

Cell G1 (formatted as percent):
=SUMPRODUCT(($B$1:$B$6="AB")*($C$1:$C$6="TR")*($D$1:$D$6="NO"))/E1
This will calculate the percentage of TR's that have NO for initials AB

In cells H1,I1,J1 put the same formulas and formats as E1,F1,G1 except change TR to TO.

[Dave Patton]

What is new with this question?
It looks very similar to the question you asked just a short while ago.

[jbyrne]

Thanks to everyone for their input. Will work on this tonight!

(posted same question twice by mistake)

Thanks again to all!