IF formulas #3

I have never created an If formula, but I assume that it is what I need.  Here is what I am trying to do -
I have a spread sheet with 4 worksheets
The first page I have a column where I put the business managers initials and the following columns have info about production and sales
The second worksheet I want it to pull all of RS's info and place it in summary for that particular person
The third Worksheet is the same concept only with JB's info
The last worksheet I am using as a "team summary"  and I can do that one
How do I get the 2nd & 3rd sheets to separate between RS & JB?
0
anonymous (74722)
4/22/2004 9:11:07 PM
excel.misc 78881 articles. 5 followers. Follow

1 Replies
502 Views

Similar Articles

[PageSpeed] 44

Hi
you may explain your data in your first sheet a little bit more (give
some example rows). Also explain your summary page (all plain text - no
attachment please)

I'd assume something like sUMIF, COUNTIF or SUMPRODUCT could do.
But also pivot tables could be a valid solution


--
Regards
Frank Kabel
Frankfurt, Germany


Bridget wrote:
> I have never created an If formula, but I assume that it is what I
> need.  Here is what I am trying to do -
> I have a spread sheet with 4 worksheets.
> The first page I have a column where I put the business managers
> initials and the following columns have info about production and
> sales. The second worksheet I want it to pull all of RS's info and
> place it in summary for that particular person.
> The third Worksheet is the same concept only with JB's info.
> The last worksheet I am using as a "team summary"  and I can do that
> one.
> How do I get the 2nd & 3rd sheets to separate between RS & JB?

0
frank.kabel (11126)
4/22/2004 9:23:08 PM
Reply:

Similar Artilces:

Dialog Box #3
I need some simple advice on how to make a dialog box launch with the auto open macro to have a value entered by the user and pasted in a cell on the worksheet. Thanks in advance. Look in VBA help for Application.InputBox I use this in an autofilter for entering are codes when filtering on phone numbers Sub Area_Code() Application.ScreenUpdating = False UserVal = Application.InputBox("Enter Area Code") If UserVal = False Then Exit Sub Else Selection.AutoFilter Field:=4, Criteria1:=UserVal & "*", Operator:=xlAnd End If Application...

Formula using hours
How can I create a formula that will say: If this cell is higher than 9:01 but but lower than 9:04 show a number? Thanks for your help! Hi Ali, =IF(AND(A1>TIME(9,1,0),A1<TIME(9,4,0),17,"") -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Ali" <anonymous@discussions.microsoft.com> wrote in message news:731101c3e72a$ceb69220$a501280a@phx.gbl... > How can I create a formula that will say: > > If this cell is higher than 9:01 but but lower than 9:04 > show a ...

Excel Formula #21
Thankyou McGimpsey for your quick reply appreciated, and the frormula also works -- SAMSON ...

Locating a file in excel with a partial file name. #3
I have been runnimg with Office 2000 with which when I go to open a file in excel I am able to enter a partial file name, any part of the file name, to search for the file I wish to open. I am finding in Excel 2002 this function does not apprear to exsit, only the function where it will search for the fille that starts with what your typing will appear once its narrowed it down to the first of a few possible options. I require the ability to be able to just go to the file open icon in excel and on the file name line be able to typr the last few chararacters of a file name to find the ...

percentage formula #2
What is the formula for using one cell to figure a percentage of another cell. Example: colume A colume B 20000 13% of colume A Thanks One way: A1: 20000 B1: =A1*13% ==> 2600 In article <093f01c3861f$4a6902d0$a301280a@phx.gbl>, "Shawn S." <shawn3731@yahoo.com> wrote: > What is the formula for using one cell to figure a > percentage of another cell. Example: > colume A colume B > 20000 13% of colume A > Thanks ...

Page Numbers #3
Is there a way to get page numbers in a workbook to run consecutively from one sheet to the next? If you select multiple sheets, then print, Excel will consecutively # the pages. >-----Original Message----- >Is there a way to get page numbers in a workbook to run >consecutively from one sheet to the next? >. > If I understand correctly, you can do this in the header/footer . You can insert the function and it will automatically number your pages. >-----Original Message----- >Is there a way to get page numbers in a workbook to run >consecutively from one sheet ...

Display Formula Problem
All, I have search Microsoft's Knowledge Base, but could not find an answer. Hopefully, someone here can solve my problem. I am using Excel 2002. I have several project managers maintaining budgets in Excel workbooks. I am creating a summary Excel workbook. To get the data out of the workbooks, I start with entering an equal sign, click on the cell in one of the other workbooks, and press enter. The value from the source workbook is displayed correctly. Since I want to capture several columns and rows around this first cell, I want to copy formula in the first cell into near cells, I mu...

subtotals #3
My worksheet contains 57,000 rows of data in the following format: Part Nbr Item Nbr Price 687223007-5 019-038 257.82 687223007-5 68-1366 20.24 687223007-5 68-1378 2.34 687223007-5 68-2232 223.68 687223007-5 68-4115 242.40 687223007-5 019-038 131.07 687223007-5 68-1366 10.12 687223007-5 68-1378 1.17 687223007-5 58-1856 4.24 687223007-5 68-2232 109.23 687223007-5 68-4115 110.80 687233016-4 019-003 76.24 687233016-4 68-2232 22.58 687233016-4 019-003 78.24 687233016-4 68-2232 27.72 687233016-4 019-003 80.78 687233016-4 68-2232 ...

Changing Business Units in CRM 3.0
Can someone confim this statement or correct me etc.........if I need to change a few users' BU (business unit no longer extsts) and they are using the CRM Client, do they need to be in off-line mode and have their most recent edits updated to system of record? On Jun 10, 1:44 am, KEO <K...@discussions.microsoft.com> wrote: > Can someone confim this statement or correct me etc.........if I need to > change a few users' BU (business unit no longer extsts) and they are using > the CRM Client, do they need to be in off-line mode and have their most > recent edits ...

Importing Address Book #3
Happy New Year to all you hard working people down there. I've tried to import my Outlook Express Address book into Outlook 2000. No matter what form I try to import with it fails. Can this be done? If so, How. File > Import and Export > Internet Mail and Addresses -- Russ Valentine [MVP-Outlook] "Rudy de Vries" <anonymous@discussions.microsoft.com> wrote in message news:007801c3d0a4$43fd8d10$a501280a@phx.gbl... > Happy New Year to all you hard working people down there. > > I've tried to import my Outlook Express Address book into > Outlook 20...

Formulas dont work
I am trying to do a vlookup function with data that is imported and calculated from another cell, and it shows a result of #na. c3 is formated to custom "m" to show the number of the month from cell b3. b3 is "October-04" c3 shows "10" d3 "job name" b100 "10" a100 =vlookup(b100,c3:f20,2,false) result is "#na" If I enter "10" into cell c3 with format set to general, then the result shows the correct answer. Is there a way to correct this? -- comotoman -----------------------------------------------------------------...

Automatic Pareto data with Formula
I want to create a data table for use to create an Automatically updated Pareto Chart, for this I need that the values automatically be sorted in descending order, so I have the following example scenario: Column A has Labels and Column B has Values A -1 B -2 C - 3 D - 2 E -1 If I use the following formula: =INDEX($A$1:$A$5,MATCH(LARGE($B$1:$B$5,2),$B$1:$B$5,0)) I get B, but there are two 2 and if I use the 3rd largest: =INDEX($A$1:$A$5,MATCH(LARGE($B$1:$B$5,3),$B$1:$B$5,0)) I also Get B instead of the required D. How can I get it so the end results looks like this: C ...

Repeating formula in Excel
Hi. I need to copy a number into 500 rows, with each number increasing by 1 in value. These numbers are used to track call numbers, so the format is like this: 2005-001 and I need it to repeat itself up to 2005-0550, and I don't want to spend the time typing each value in manually. Someone please help!!! One way: Delete the dash from your number. Select the cell with the number. Go to Format | Cells | Number. Choose Custom and type: 0000-000 click okay. Then, (still with the same cell selected) go to Edit | Fill | Series. Make sure the Step Value is 1. Change to Columns and put a s...

FORMULAS please help
Hi there I am trying to create a formula that refences <> numbers in a columm then adds up the from a different columm i.e add b1:b100 only if a1:a100 is >10000 <12000 =46 a b 10000 32 9000 64 12001 86 11999 14 9990 12 One way =SUMPRODUCT(--(A1:A100>10000),--(A1:A10000<12000),B1:B10000) Regards, Peo sjoblom boogie wrote: > Hi there > I am trying to create a formula that refences <> numbers in a columm then > adds up the from a different columm > i.e add b1:b1...

Replacing formula to cells EXTREMELY slow
Hi! I have the following code ------------------------------------------------------------------------------ Private Sub ToggleButton3_Click() Dim i As Long Dim Lastrow As Long Application.ScreenUpdating = False Lastrow = 1000 If ToggleButton3.Value = True Then 'Fill in the checking formula For i = 0 To 5 Cells(4, i + 9).Formula "=IF($A4="""","""",COUNTIF(INDEX('Check'!4:4,1,$AI$2):INDEX('Check'!4:4,1,$AI$3), & i & "))" Next Else For i = 0 To 5 Cells(4, i + 9).Formula "=IF($A4="""",...

Formula help needed
Can someone help me to shorten this formula, it slows down my computer so it takes ages to recalculate the sheet when I enter something in it. It is used to calculate time, basic formula (A2-A1+(A2<A1)) from C Pearsson�s site OFFSET(INDEX(Tid3;MATCH(A8&1;Feb!$A$9:$A$250&Feb!$B$9:$B$250;0);MATCH(Feb!$C $8;Feb!$A$8:$D$8;0);1);1;0)-INDEX(Tid3;MATCH(A8&1;Feb!$A$9:$A$250&Feb!$B$9:$ B$250;0);MATCH(Feb!$C$8;Feb!$A$8:$D$8;0);1)+(OFFSET(MATCH(Tid3;PASSA(A8&1;Fe b!$A$9:$A$250&Feb!$B$9:$B$250;0);MATCH(Feb!$C$8;Feb!$A$8:$D$8;0);1);1;0)<IND EX(Tid3;MATCH(A8&1;Feb!$A$9:$A$...

Help With an Excel Formula
I am in excel and I have the following formula = Q:26 typed into Cell C:2. What I want to do is have a second cell D:2 that takes what ever cell reference I enter into C:2 and adds 1 row to it. So cell D:2 would be equal to Q:27, which is 1 row down from row Q:26. Is there a way to do this? Not possible unless you use an add-in or user define function that reads the text of the formula in C2 D McRitchie has UDF for that http://www.mvps.org/dmcritchie/excel/formula.htm then you could use =OFFSET(INDIRECT(SUBSTITUTE(getformula(C2),"=","")),1,) Regards, Peo Sjobl...

DREMEL 1/32 Engraving Cutter (3/32 Shank), Part No. 111
Price:$2.66 Image: http://thediscountdatabase.info/image.php?id=B000WE5NV0 Best deal: http://thediscountdatabase.info/index.php?id=B000WE5NV0 The Dremel rotary tool is lightweight, compact and versatile, which makes it very "friendly". This tool works differently from any other tool you've ever owned. With more than 150 available accessories, you can use it to cut, sand, shape, drill, buff, g ...

Navigation Bar #3
I am having problem with the navigation bar on the bottom of my web page. The links seem to be properly set up and work while working inside publisher. Once I preview as a web page or publish, the links no longer work. Any thoughts? Thank you! You did not specify what version of Publisher you are using or which browser, but it sounds like you are previewing the site in FireFox. The bottom navbar is converted to an image in both Pub 2003 and 2007 webs for the version of the web pages that are rendered by FireFox. The html coding engine produces a different version for IE. The fix for this...

Help simplifying a SUMPRODUCT formula
The following SUMPRODUCT formula produces the correct results but I'm reasonably certain that there must be a more efficient way of constructing the formula. There are basically two components to this formula separated by the + sign. Each component performs the same calculation: the first part for Class="MS" and the second part (after the +) for Class="MSTV". Isn't there a way to construct the formula so that it would be calculated for Class="MS" OR Class="MSTV" and eliminate the need for two steps? I tried to incorporate the OR formula wi...

Outlook Task #3
I would like to use outlook as a tickle file - ie - If someone ask me to check back with them in tow weeks - I would like to set upa task to call the person back on the date that is tow eek away. I have alot of task - so I really do not want to show the task in my task list until that day. Ah yes a tickler system. Easy if you have any version APART from 2007. You forgot to post your version. Judy Gleeson MVP Outlook Outlook trainer and author of Productiv_IT with Outlook www.judygleeson.com www.acorntraining.com.au Canberra, Australia In mathematics you don't understand things. Yo...

Headers #3
How can I select a cell or range of cells for a header instead of an entire row or column? If you are talking about freezing the top row(s) for display showing only some cells on the row, Or repeating rows or columns for printing then the answer is that you can't. http://www.mvps.org/dmcritchie/excel/freeze.htm If for printing you could change the color of the font for the other cells so they don't show. If you want something like a dictionary reference, or a telephone book reference showing to first entry on the page and the last entry on a page like kel-mcr then yo...

Trend Formula
What does the symbol E stand for in excel graphical trend formula? Is it 10, or exponential e? When I try to test the formulae I get the correct x=0 point but others are wrong; either way. I am using an x raised to the power 5 polynomial A number such as 1.234E-3 is to be read as 1.234�10^(-3) or 0.001234 Copying the trendline equation values can give terrible results unless you first format the equation for maximum precision Better yet use LINEST to but values into cells that you can reference to generate the forecast values See http://people.stfx.ca/bliengme/ExcelTips/Polynomial.htm ...

help with formula #9
G12 has a dropdown menu in it, Y for YES, N for NO. I12 is where the answers will go. So if I pick N from the dropdown box in G12 , I need it to show a answer of 0 in I12. If I choose Y in cell G12 , I need it to use this formula =Roundup(E12/300,0) so that it will give me a answer in cell I12. How to I write this and get it to work? Place in I12: =IF(G12="Y",ROUNDUP(E12/300,0),0) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Art" wrote: > G12 has a dropdown menu in it, Y for YES, N for NO. > I12 is where the answers will go. > So if ...

Everyone group #3
Hey! Are there a few alternatives as far as setting up an "Everyone" group in Exchange 2003? Obviously can't name it "Everyone" because it conflicts with the system group with the same name... Or can I mail enable the system group? TIA! / Per Hagstrom On Mon, 17 Jul 2006 12:05:40 -0500, "Per Hagstrom" <poh@charter.NOSPAMnet> wrote: >Hey! > >Are there a few alternatives as far as setting up an "Everyone" group in >Exchange 2003? > >Obviously can't name it "Everyone" because it conflicts with the syste...