Work spreadsheet issue

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.

Can you provide a sample of your data along with your expected results?

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.

How do you know who's being promoted, and in which quarter?

Originally Posted by Domenic

How do you know who's being promoted, and in which quarter?

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!