Link between worksheets

  • Thread starter Thread starter Linker
  • Start date Start date
L

Linker

I have gotten myself into a project at work and cant seem
to come up with a way to finish it... if its at all
possible. I will show below what I am doing to try to set
up ye ole plot...

NAME JAN FEB MAR APR MAY JUNE ETC

Here what I will do is put in a workers name, and under
each month there is a drop down down(A,B,C) for a rating..

On another sheet I have.

NAME A B C

Here what I want to do is take a tally of how many times
in sheet1 "A" was chosen in January for example, and put
that tally for that person into sheet2 under A.

Example:
(SHEET1)

NAME JAN FEB ETC
JOHN DOE A
BILLY BOB A
JOHN DOE C
JOHN DOE A
BILLY BOB B

(SHEET2)(Shows how many times from sheet1 doe and bob
had "A","B","C" for the month of January

NAME A B C
BILLY BOB 1 1
JOHN DOE 2 1

Is this possible or am I off in LaLa Land? :)
If any excel master is out there and can help it would be
greatly appreciated...

Thank You..
Lost Linker :)
 
Linker, working from your example, if your data on Sheet2 begins in Cell A1,
put this in Sheet2, Cell B2:

=SUMPRODUCT((Sheet1!$A$2:$A$6=$A2)*(Sheet1!$B$2:$B$6=B$1)).

Copy it down and to the right. Assumes that the names are on Sheet1, in
A2:A6 and the January ratings are in B2:B6.
 
Back
Top