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.


-- 
jenrenea
------------------------------------------------------------------------
jenrenea's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=23098
View this thread: http://www.excelforum.com/showthread.php?threadid=373900

0
5/25/2005 2:56:02 PM
excel 39879 articles. 2 followers. Follow

5 Replies
873 Views

Similar Articles

[PageSpeed] 14

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


-- 
Domenic
------------------------------------------------------------------------
Domenic's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=10785
View this thread: http://www.excelforum.com/showthread.php?threadid=373900

0
5/25/2005 3:16:19 PM
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     |
+-------------------------------------------------------------------+

-- 
jenrenea
------------------------------------------------------------------------
jenrenea's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=23098
View this thread: http://www.excelforum.com/showthread.php?threadid=373900

0
5/25/2005 3:52:05 PM
How do you know who's being promoted, and in which quarter

--
Domeni
-----------------------------------------------------------------------
Domenic's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1078
View this thread: http://www.excelforum.com/showthread.php?threadid=37390

0
5/25/2005 4:32:52 PM
Domenic Wrote: 
> 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.


-- 
jenrenea
------------------------------------------------------------------------
jenrenea's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=23098
View this thread: http://www.excelforum.com/showthread.php?threadid=373900

0
5/25/2005 4:41:32 PM
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     |
+-------------------------------------------------------------------+

-- 
Domenic
------------------------------------------------------------------------
Domenic's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=10785
View this thread: http://www.excelforum.com/showthread.php?threadid=373900

0
5/25/2005 5:22:44 PM
Reply:

Similar Artilces:

Agent version issue on secondary DPM
I am trying to restore a secondary DPM server back to working order by reinstallation of the OS (server 2008 R2), installation of DPM 2007, installation of DPM 2007 SP1, and installation of hotfix KB976542. Following this I restore the DB using "dpmsync -restoredb -dbloc mypath\dbdpm.bak" then resyncing with "dpmsync -sync". My replicas were preserved. However, I'm having an agent problem with my primary server. If I try to install the agent on the primary server, I get an error 372: The agent operation failed because DPM detected a more recent versio...

is it possible to add a MACRO to a Spreadsheet from VB app??
...

Can I embed my Outlook Calendar into an Excel Spreadsheet?
Not to my knowledge, no. You can export from Outlook... ************ Hope it helps! Anne Troy www.OfficeArticles.com "trando69" <trando69@discussions.microsoft.com> wrote in message news:0F25CA58-EAA7-46E3-80B0-78215EEF2440@microsoft.com... > ...

New Ex2003 SP2 installation teething problems. (Outlook issues)
Hi, I have just installed a new Ex2003 sp2 server for a customer. It is an upgrade from a 7 year old Ex5.5 server. The 5.5 server is still up and running, as I have to debug a few EX 200 problems. The first one is causeing me a major headache, the rest are minor) 1 - Outlook - can not use cached exchange mode. As soon as I turn that on in the outlook profile, the users are unable to open outlook sucessfuly 2 - IMF filter - where does the Archive option save the messages? 3 - Global Adress list - on the old 5.5 server in the recepients folder I used to create aliases for the HK and Ch...

why do the weblinks in my publisher document no longer work in a .
In my publisher document all the links seem to work (cntl+click). But in an e-mail the navigation links to other pages (in the document, I inserted a navigationbar) are not working. (Because an email is only one page?) and: In the same document previewed as a webpage the navigation links to other pages continue to work, but now the links to websites and e-mailadresses no longer exist. I want to make an e-mail(newsletter) with the possibility to click to next pages. Is that possible in Publisher 2003? How? hajohbo wrote: > In my publisher document all the links seem to work (cntl+cl...

Looking for a working production formula so I can add to staff?
I'm looking to justify addition to the staff I support. Is there a common formula that is used that include production standards and time worked? ...

My News menu button does not work correctly.
My News menu button does not work correctly. When clicked, it brings up th file folder 1033, and can not be deleted. Why? How can I remove this "News" button and then enter into the news reader? ...

SP2 & OWA only IIS direct login works
I installed SP2 over the weekend and the only way to log into OWA is to go into IIS and select the Exchange folders and say browse. This will browse the Administrator account just fine, but if you try to log in as any other user it starts to load OWA but it does not look right the Fonts are wrong as well as button placement then it gets stuck saying loading and says there are errors in the page. Any ideas would be great Thanks Heith On Tue, 27 Dec 2005 12:39:09 -0800, "Heith" <hcook@connect-it.biz> wrote: >I installed SP2 over the weekend and the only way to lo...

Outlook 2010 work offline / work online
My Outlook 2010 is always set work offline. Is there a way to reverse this setting in Otlook 2010? ...

Animate menus option in Outlook 2003 won't work...
Hi, I have MSOffice 2003 installed on my laptop along with Windows XP SP2. I have been trying to make the "Animate manus" option work. Hower I can't get the thing to save and run the animation I have selected. I have selected the "unfold" animation, and even though it is selected, the option does not seem ever to work. I have tried rebooting my machine and no dice. I know this is extremely trivial, but I was wondering if anyone knows how to enable this. Is there another setting that has to be turned 'on' for this feature to work? thanks, joe ...

Can't get autocomplete to work
I've just begun using Money 2007 and thought it is switched on in the settings, AutoComplete does not work. Might this be because I have to import my account data instead of using an automated online service (my bank does not offer that)? Could somebody explain to me how AutoComplete is supposed to work? AutoComplete A Money feature that automatically finishes filling in a name when you begin to type one that you've used before. You can accept the name Money suggests or finish typing a new one. For more info... Open Money, activate F1 key on the keyboard, input AutoComplete in t...

Workflows that dont work
I have found that it if i am logged on as administrator who is not a user of CRM and create a Workflow rule, it will never run. However, If I log on as a CRM admin, reopen the rule, then save it, the workflow works everytime. So, when ever someone creates a workflow, calls me on the phone, I now tell them this first, it seems to fix the problem more often then not. More to the point, Microsoft will tell you every time that workflows should be created by a CRM administrator who is not in restricted access mode. "Dan white" wrote: > I have found that it if i am logged on a...

Countif not working if a cell contains a formula?
Hello, I have a number of rows where I am checking for some text within the row and fill in a cell at the end of the row with "true" or "false" depending on whether the cell contains the word. Each cell that is doing the checking has the following equation =IF(ISNUMBER(FIND("Darren",D**)),"true", "false") where D** matches the row that the cell is in. I then want to count the number of cells which contain the word "true" and have the following in the cell at the bottom of the column =COUNTIF(I3:I102,"true") This return...

combine info in spreadsheet
I'm trying to combine some info that looks like: A B C amount name accountname 100 joe account1 150 joe account1 130 joe account1 110 joe account2 125 joe account2 150 jon account3 150 jon account3 150 tom account4 150 tom account4 150 tom account4 I would like to combine the data by account name, totalling the amounts but still showing who it belongs to in column b. Any ideas. Thanks in advance. Hi use a pivot table. See: http://www.cpearson.com/excel/pivots.htm http://peltiertech.com/Excel/Pivots/pivotstart.htm...

How can I update an MS Access table record from within Execl works
In my Excel spreadsheet, I have created a link to an MS Access database table, where it imports data from Access to Excel. Now from that same Excel spreadsheet, I want to find a way to update (change) a record in the MS Access database table. Is there anyway to do this? Thanks, David ...

How do I enter a working check box option in Excel?
I am trying to insert a "check the box" option in Excel and then use an "if checked, then do xxx" formula to calculate various sales projections based on which mix of product lines are checked. I am able to insert the Wingding character that looks like the check off box, but it just sits there like clip art with no functionality, so I am either not taking it far enough or just going about it all wrong. I am using several different versions of Excel to do this project depending on where I am at the time (home, work, laptop) so I can set it up in whichever is easiest...

Memo field issues
Using Office 2003 and Windows XP; I have a text box control on a form that updates a memo field in a table. The control is not bound. I am using ADO to upload the data (Currentproject.Connection.Execute sSQL). The update saves several controls at once to fields in a single table. I want to be able to enter research notes into the text box that could include international characters, commas, apostrophe's, and virtually any other characters you would find on a keyboard; and also new paragraphs, etc. I'm having a problem in that I can enter a certain amount of data and it works ...

O2003 and Achiving issue
Hi Guys, any one else notice that sometimes when you kick off archiving that it just sits on "Archiving Favorite FOLDERS." for ever? Even when I cancel it, I can't start archiving again (complains that archiving is already running), without quitting Outlook and running it again. I'm assuming that "Favorite FOLDERS" is the "Favorite Folders" that appears on the left when I look at Mail. This currently contains "Unread Mail (223)" and "For Follow Up [1]", which can't take all that long to archive (not that these should be archived...

Auto Increment Office XP Excel Spreadsheet ?
I have Excel and would like to have my first column auto increment so that if add new rows it will auto update the the numbers. Something like: 1. 2. 3. and so on How can I make the first column in every row auto increment? Thanks so much in advance! Chris There's no automatic way. You can use a formula (or a range name) that takes the number in the cell above and adds one to it. However, if you insert a row in between other rows in your list you'll still have to copy the formula/range name down from the cell above. There is a Data-->Form command that allows you to enter lis...

Electronic signing for an Excel Spreadsheet
I have developed a form which will be completed by one person then forwarded to a second person (Supervisor) who needs to approve it then it needs to be forwarded to me for final action. It is a payroll form so I need to ensure the proper supervisor has seen and approved the form and no one else has forwarded it to me (i.e. the employee). There are about 160 employees and probably 15-20 supervisors. Any ideas would be appreciated. Hi Lee Bob, You could provide the supervisors with unique passwords which they can then "sign" the work off with. I suggest passwords because th...

Works 3.0 to Excel v.X mac
How do i convers Works 3.0 spreadsheets to Excel v.X Mac? help! If you were running Windows, the answer would be to open the sheet in Works and save it in an Excel format. I don't know if that will work with a Mac or not. On Mon, 1 Sep 2003 17:52:23 -0700, "JFNCO" <jfnco@earthlink.net> wrote: >How do i convers Works 3.0 spreadsheets to Excel v.X Mac? help! In article <032201c370ec$7887e2f0$a601280a@phx.gbl>, "JFNCO" <jfnco@earthlink.net> wrote: > How do i convers Works 3.0 spreadsheets to Excel v.X Mac? help! Well, the deluxe route wou...

0x8007041D Issue
Not able to get Windows update to run. Go to Windows Update, it says something failed. Re-register as recommended. After 100% it gives 0x8007041D error. BITS is running. Automatic Update svc cannot run. Please help. thanks. cacheboy75 wrote: > Not able to get Windows update to run. > Go to Windows Update, it says something failed. Re-register as recommended. > After 100% it gives 0x8007041D error. > > BITS is running. > Automatic Update svc cannot run. > > Please help. thanks. No AU service is an indication that the OS is either XP/WS2K3/W2K. ...

IMFV2 not working on Exchange SP2
Hello together, I have a problem with my IMF on a SBS2003 server. The problem ist described here: http://www.vladville.com/articles/exchangesp2imf.asp "1. IMF stops working because IMF v1 was not removed prior to the SP2 installation." I think the failure was, I had not deinstalled the IMFV1 first time I installed Exchange SP2. But I removed IMFV1 later, installed the SP2 again. But IMFV2 ist not working. But what can I do? I don't found any tipps in internet. Is the only way a new installation of the server in the "right order"? Thanks Karl - Is there a M...

My Resources Unsubmitted Timesheets not working (MSPS 2007)
When I go to Tmesheet Approvals and select "My Resources Unsubmitted Timesheets" and click Apply I never see any timesheets. I only see timesheeets once they are submitted for approval. I configured myself as an administrators to give miall rights and still can not see any unsubmitted timesheets. Any help? Bug? Gary You must be set as a user's Timesheet Manager in order to see their Unsubmitted Timesheets. So, for example, if your organization is not using Fixed Approval Routing and you are a secondary approver, you will not see anything in My Resources ...

Spoke to soon Reports not working
Getting RequestTime outs when the viewer is being installed...Or directly after when the report is being served.... Microsoft CRM Report Viewer page comes up then it just hangs until ASP.NET Request.Timeout exception shows up on the page. ...