Work spreadsheet issue

  • Thread starter Thread starter jenrenea
  • Start date Start date
J

jenrenea

If I have multiple rows of data on a worksheet and on another worksheet
I want various counts of rows that have certain things in common, how
would I do that? Thanks.
 
The top portion is my information I'm working with. Basically it's a
"fake" of our current staff and their positions and expected promotion
date.

The second page highlighted needs filled....


So from page one I need everyone in section 44, who is a territory
sales manager, who is being promoted in quarter 3 2005, in the right
spot on the second page.... but I need to where if we add another
person.. it will all populate correctly.


Does this make sense?


This is a little out of my league...I don't generally do this stuff.

Sorry about the monochrome... it was the only way to get it small
enough.


+-------------------------------------------------------------------+
|Filename: untitled2.bmp |
|Download: http://www.excelforum.com/attachment.php?postid=3422 |
+-------------------------------------------------------------------+
 
Domenic said:
How do you know who's being promoted, and in which quarter?
Click to expand...


Under the Anticipated Advancement Date column, it is listed as a date
(i.e. Sep-05), but there are only about 20 listed. I believe only
section 44 has theirs filled out thus far.
 
If you're willing to make a few changes/additions to your spreadsheet,
as highlighted in yellow in the attached files, you could use the
following formula...

C29, copied to other cells:

=SUMPRODUCT(--(Sheet1!$A$12:$A$100=Sheet2!$A29),--(Sheet1!$E$12:$E$100=Sheet2!$B29),--(Sheet1!$I$12:$I$100=Sheet2!C$28),--(Sheet1!$J$12:$J$100=Sheet2!C$27))

Adjust the ranges accordingly.

Hope this helps!


+-------------------------------------------------------------------+
|Filename: Sheet2.jpg |
|Download: http://www.excelforum.com/attachment.php?postid=3425 |
+-------------------------------------------------------------------+
 
Back
Top